Thread: If Criterias
View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.misc
David Biddulph[_2_] David Biddulph[_2_] is offline
external usenet poster
 
Posts: 8,651
Default 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