rajendradk9
New Member
- Joined
- Aug 3, 2013
- Messages
- 39
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
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