Hi,
I need help with an IF formula which is based on two different criteria. Please see attached example:
Any suggestions are appreciated.
Thanks!
Hi,
I need help with an IF formula which is based on two different criteria. Please see attached example:
Any suggestions are appreciated.
Thanks!
Try:Formula:Please Login or Register to view this content.
Trevor Shuttleworth - Retired Excel/VBA Consultant
I dream of a better world where chickens can cross the road without having their motives questioned
'Being unapologetic means never having to say you're sorry' John Cooper Clarke
In C6, try this:
=IFS(A6="Red","OK",A6="Blue",IF(AND(B6>0,B7>0),"Yes","No"))
Then copy this to C11 and C14
FormulaFormula:Please Login or Register to view this content.
Sorry, didn't read the requirements properly so my formula only returns Yes or No, not OK for Red.
Note that, in your sample file, Red in A6 has a trailing space which will affect the results.
This is another alternative:Formula:Please Login or Register to view this content.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks