If Formula question

[Guest]

Please take a look at this formula and please tell me what is obviously
escaping me to accomplish the following:

=IF(K5="APPROVED","APPROVED",IF(Q5="APPROVED","APPROVED")

What I am trying to add to this is IF either cell does NOT have APPROVED in
it, I want this target cell (V5) to either be blank or say "pending";
whichever is easier. But, whenever I tried to add the FALSE argument, I got
an error message.

Can someone please help?

 

[Alan]

Hi,
=IF(K5="APPROVED","APPROVED",IF(Q5="APPROVED","APPROVED",""))
or
=IF(K5="APPROVED","APPROVED",IF(Q5="APPROVED","APPROVED","Pending"))
Regards,

 

[Bob Phillips]

=IF(OR(K5="APPROVED,Q5="APPROVED"),"APPROVED","pending")

 

[Guest]

Thank you both ----once again, the newsgroup saves the better part of my day!!