• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

if statement - Need Immediate HELP

Aviz8945

New Member
Please let me know, how can I put these all condition in a formula??? I tried "If" but isn't working.

Many Thanks in Advance


Condition 1

IF C = 0

IF B = 0

Then A X E


Condition 2

IF C = 0

IF B > 0

Then (A - B) X E


Condition 3

IF C > 0

IF B = 0

Then A X E


Condition 4

IF C > B

Then (A - B) X D


Condition 5

IF C < B

Then (A - B) X D


Condition 6

IF C = B

Then (A - B) X D
 
=if(and(c>=0,b=0),a*e,if(and(c=0,b>0),(a-b)*e,(a-b)*e))


since the conditions 1,3 and 4,5,6 have same outcomes, I have shrunk them. If you need different outcomes, expand those portions to test individual conditions.
 
Back
Top