IF Function For Multiple Condition

[rajendradk9]

HI, I'm trying solution as mentioned below so need your support.
Having Column A B C D each are having Numeric value, based on this need two results as mentioned below in same cell

A+B-C*D<=0 Then Result should be 0 , A+B-C*D>0 Then Result should be A+B-C*D

For Example 20+40-6.45*20=0 , 60+20-6.45*2=67

 

[Fluff]

How about
=IF(A2+B2-C2*D2<0,0,A2+B2-C2*D2)

 

[Eric W]

Or:

=MAX(0, A2+B2-C2*D2)

 

[Fluff]

?‍ new I was missing something

 

[rajendradk9]

=IF(A2+B2-C2*D2<0,0,A2+B2-C2*D2)

Thank you working fine

 

[rajendradk9]

C2

Thank you working fine