 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
| HomeDiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWordDirectoryUser Groups Related Topics Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ... |
MS Office Forum / Excel / Worksheet Functions / November 2006conditinal If statement with 3 outputs
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 =IF(P11=100,"Yes",IF(P11=10,"N/A","No"))  SignatureHTH Bob Phillips (replace somewhere in email address with gmail if mailing direct) > Hello, > [quoted text clipped - 15 lines] > > Clive Hi Or =IF(P11=10,"N/A",P11=100) SignatureArvi Laanemets ( My real mail address: arvi.laanemets<at>tarkon.ee ) > =IF(P11=100,"Yes",IF(P11=10,"N/A","No")) > [quoted text clipped - 17 lines] >> >> Clive Huh? Can you explain that to me as it doesn't do what I interpret the OP is asking. SignatureHTH Bob Phillips (replace somewhere in email address with gmail if mailing direct) > Hi > [quoted text clipped - 22 lines] > >> > >> Clive Sorry! In some systems Yes/No are boolean values like True/False - so without any thougth I assumed OP needs answers to be boolean too. In Excel my formula returns True or False or N/A of-course. Not exactly what OP asked for. SignatureArvi Laanemets ( My real mail address: arvi.laanemets<at>tarkon.ee ) Phew! I thought I was losing it <G> Bob > Sorry! In some systems Yes/No are boolean values like True/False - so > without any thougth I assumed OP needs answers to be boolean too. > > In Excel my formula returns True or False or N/A of-course. Not exactly what > OP asked for. 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?] SignatureDavid Biddulph > Huh? Can you explain that to me as it doesn't do what I interpret the OP > is > asking. >> Hi >> >> Or >> =IF(P11=10,"N/A",P11=100) >> > =IF(P11=100,"Yes",IF(P11=10,"N/A","No")) >> > [quoted text clipped - 17 lines] >> >> >> >> Clive Hi > 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?] As my answer was based on Bob's response, 10 originates from there :-))) (Sometimes it's confusing not to read previous postings carefully enough - but I was too short of time at this moment) Arvi Laanemets > -- > David Biddulph [quoted text clipped - 36 lines] > >> >> > >> >> Clive =IF(P11=100,"Yes",IF(P11=0,"N/A","No")) SignatureDavid Biddulph > Hello, > [quoted text clipped - 15 lines] > > Clive |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.