If Criterias
 

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 B1C1 then in A1 appears NOT GOOD
in B1=C1 then in A1 appears GOOD
Thanks for help

If Criterias
 

=IF(B1=0,"BAD",IF(B1C1,"NOT GOOD",IF(B1=C1,"GOOD","result undefined")))
--
David Biddulph

"Ricardo" wrote in message
...
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 B1C1 then in A1 appears NOT GOOD
in B1=C1 then in A1 appears GOOD
Thanks for help

If Criterias
 

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

M

"David Biddulph" wrote:

=IF(B1=0,"BAD",IF(B1C1,"NOT GOOD",IF(B1=C1,"GOOD","result undefined")))
--
David Biddulph

"Ricardo" wrote in message
...
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 B1C1 then in A1 appears NOT GOOD
in B1=C1 then in A1 appears GOOD
Thanks for help

If Criterias
 

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

"santaviga" wrote in message
...
you can also try the conditional formatting of that cell to the specific
values and return the outcome.

"David Biddulph" wrote:

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

"Ricardo" wrote in message
...
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 B1C1 then in A1 appears NOT GOOD
in B1=C1 then in A1 appears GOOD
Thanks for help