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!

2. Re: Trying to make this equation work!

what happens if anything = 0 ?

4. Re: Trying to make this equation work!

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

Thanks

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

Try this:

``Please Login or Register  to view this content.``
Cheers,

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"))

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

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

There are currently 1 users browsing this thread. (0 members and 1 guests)

Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1