vendredi 18 mai 2018

if 2 cells blank, then do if statement, if 3rd cell is not blank, then do if statement

Multiple criteria if statement, based on blank and non blank cells returning different "true" statement.

If cells K (DATE) and F (dollar amount) are blank, then if cell F=500 then "REQUEST" otherwise "" I have this portion of the formula working: =IF(OR(ISBLANK(K49), ISBLANK(F49)),"",IF(F49=500,"REQUEST","")))

I need to add another if statement based on cell I49 (DATE) and the below works alone, not combined with the above formula. =IF(AND(ISBLANK(I49)),"RCVD","") Any help is appreciated. Thank you.

Aucun commentaire:

Enregistrer un commentaire