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