# Turn this "if" "or" statement into an excel formula

1. ## Turn this "if" "or" statement into an excel formula

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!  Register To Reply

2. ## Re: Trying to make this equation work!

what happens if anything = 0 ?  Register To Reply

3. ## Re: Trying to make this equation work!  Register To Reply

4. ## Re: Trying to make this equation work!

Told you I'm toast...change the < to <=

Thanks  Register To Reply

5. ## Re: Turn this "if" "or" statement into an excel formula

Try this: ``Please Login or Register  to view this content.``
Cheers,  Register To Reply

6. ## Re: Turn this "if" "or" statement into an excel formula

=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"))  Register To Reply

7. ## Re: Turn this "if" "or" statement into an excel formula

Thanks, I was missing one scenario, but I added it...thanks!  Register To Reply