Hi

Or
=IF(P11=10,"N/A",P11=100)


--
Arvi Laanemets
( My real mail address: arvi.laanemets<attarkon.ee )


"Bob Phillips" wrote in message
...
=IF(P11=100,"Yes",IF(P11=10,"N/A","No"))

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

wrote in message
oups.com...
Hello,

I have a conditional if statement with 2 conditions.
If condtion 1 is satisfied I would like to display "Yes"
If Conditions 2 is satisfied I would like to display "N/A"
else display "No"

is this possible? as there only seems to be room for a value if true
and a value if false.

I tried doing it this way

=IF(P11=100,"Yes","No")or(P11=0,"N/A","No")

but excel kept telling me to get lost.

Any suggestions would be greatly appreciated.

Clive