Trying to make this equation work:
IF A = "Standard" then,
IF B>0 then C
IF B<0 then D
OR
IF A = "Non-Standard" then,
IF B>0 and E<0 then C
IF B<0 and E<0 then D
Shouldn't be this difficult, but my brain is toast right now!
Trying to make this equation work:
IF A = "Standard" then,
IF B>0 then C
IF B<0 then D
OR
IF A = "Non-Standard" then,
IF B>0 and E<0 then C
IF B<0 and E<0 then D
Shouldn't be this difficult, but my brain is toast right now!
Last edited by rmichaels55; 04-22-2009 at 05:39 PM. Reason: Change title
what happens if anything = 0 ?
"Unless otherwise stated all my comments are directed at OP"
Mojito connoisseur and now happily retired
where does code go ?
look here
how to insert code
how to enter array formula
why use -- in sumproduct
recommended reading
wiki Mojito
how to say no convincingly
most important thing you need
Martin Wilson: SPV
and RSMBC
Please read the forum rules about thread titles, and then amend yours.
Entia non sunt multiplicanda sine necessitate
Told you I'm toast...change the < to <=
Thanks
Try this:
Cheers,Please Login or Register to view this content.
Would you like to say thanks? Please click the: " Add Reputation" button, on the grey bar below the post.
CL code with little change of <= addition of = sign in >
=IF(A1="Standard",IF(B1>0,C1,D1),IF(A1="Non-Standard",IF(AND(B1>0,E1<=0),C1,IF(AND(B1<=0,E1<=0),D1,"Conditions not met")),"Conditions not met"))
Thanks, I was missing one scenario, but I added it...thanks!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks