If Criterias

R

Ricardo

Hi
I need to put in the same cell 3 differents criterias
ex: in cell A1
if B1=0 then in A1 appears BAD
if B1>C1 then in A1 appears NOT GOOD
in B1=C1 then in A1 appears GOOD
Thanks for help
 
D

David Biddulph

=IF(B1=0,"BAD",IF(B1>C1,"NOT GOOD",IF(B1=C1,"GOOD","result undefined")))
 
S

santaviga

you can also try the conditional formatting of that cell to the specific
values and return the outcome.

M
 
D

David Biddulph

Could you explain that in more detail, please? If the OP isn't confused by
your reply, I certainly am. :)
 
Top