mercredi 18 avril 2018

Incorrect Formula for nested if loops in Excel

Problem:

If K2 is blank AND N2 is blank = P2-I2 If K2 is blank = P2-L2 ELSE P2-O2

New to writing if statements with excel, but this is my formula and I am having a hard time catching my mistake:

IF(AND(ISBLANK(K2), ISBLANK(N2)), P2-I2, IF(ISBLANK(N2), P2-L2, P2-O2))

I am pasting that after the "=" into excel. Any help would be great!

Aucun commentaire:

Enregistrer un commentaire