Hi,
I have the formula below.
I want to add an "or" statement to the formula so that Q380 can = 0 or ISNA for the statement to be true (along with the other statements below).
Current Statement
=IF(AND(ISNA(Q380),S380=0,T380=0,R380=0),E380,"")
How can I do that?
Thanks,
Jason
Sounds like what you want is
=IF(AND(OR(ISNA(Q380),Q380=0),S380=0,T380=0,R380=0),E380,"")
ChemistB
My 2˘
Don't forget to mark threads as "Solved" (Edit First post>Advanced>Change Prefix)
If I helped, Don't forget to add to my reputation (click on the little star at bottom of this post)
Maybe
=IF(AND(OR(ISNA(Q380),Q380=0),S380=0,T380=0,R380=0),E380,"")
EDIT: Simultaneous posting with ChemistB, who
Люди, питающие благие намерения, как раз и становятся чудовищами.
Regards, «Born in USSR»
Vusal M Dadashev
Baku, Azerbaijan
OK - sees logical but surprisingly I am getting an answer of #N/A when there is #N/A in the Q380 cell.
You're right. Didn't think it through. Excel tries to determine if Q380 = 0 and that screws up the formula. You'll need nested IFs like so
=IF(AND(S380=0,T380=0,R380=0,E380SNA(Q380)),E380,IF(AND(Q380=0,S380=0,T380=0,R380=0),E380,""))
Does that work for you?
Last edited by ChemistB; 08-12-2010 at 12:41 PM.
ChemistB
My 2˘
Don't forget to mark threads as "Solved" (Edit First post>Advanced>Change Prefix)
If I helped, Don't forget to add to my reputation (click on the little star at bottom of this post)
One alternative might be:
=IF(AND(ISNA(MATCH(SIGN(Q380),{-1,1},0)),COUNTIF(R380:T380,0)=3),E380,"")
My Recommended Reading:
Volatility
Sumproduct & Arrays
Pivot Intro
Email from XL - VBA & Outlook VBA
Function Dictionary & Function Translations
Dynamic Named Ranges
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Reply With Quote
Bookmarks