Arvi was presumably offering TRUE and FALSE as an alternative to the Yes and
No that the OP requested?
[And his P1=10 is presumably a misprint for the OP's P1=0, as I guess yours
was?]
--
David Biddulph

"Bob Phillips" wrote in message
...
Huh? Can you explain that to me as it doesn't do what I interpret the OP
is
asking.

"Arvi Laanemets" wrote in message
...
Hi

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

"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