Formula for + and - minus sign

[Sarfraz Khan]

Dear Sir,

If Dr Amt is in Plus sign and Cr amt is in minus sign then formula should be Dr + Cr = 0
If Dr Amt is in Plus sign and Cr amt is ALSO in plus sign then formula should be Dr - Cr = 0
How to apply the formula.

 

[Chihiro]

Use IF statement. But you didn't specify what should happen if Dr amount is negative.

=IF(AND(B3>0,C3>0),B3-C3,B3+C3)

 

[Somendra Misra]

Hi,

Just another option. In D3:
=B3-ABS(C3)

Regards,

 

[srinidhi]

If Dr is always +, then here is a shorter formula =IF(C3<0,B3+C3,B3-C3)