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