Formula

[dazoloko via OfficeKB.com]

Dear All

Im wandering if someone can assist.

I have two columns each containing a Monetary Value

Amount Chargeable and Potential Charge

Im after an If formula to calculate in a third column the actual charge based
on the following scenarios

If the Amount Chargeable is greater than Potential Charge then the Actual
Charge = Potential Charge

If Amount Chargeable = 0 then Actual charge = 0

If Amount Chargeable is less than Potential Charge then Actual Charge =
Difference between Potential Charge and Amount Chargeable.

Hope this makes sense.

Cheers

D

 

[Dennis]

Using A1, B1 and with your formula in C1 (You have not got a condition for
Amount chargeable being the same as potential so I have used the same as
being greater than Potential)

=IF(A1=0,0,IF(A1>=B1,B1,B1-A1))

 

[Barb Reinhardt]

=IF(A2 > B2, B2,IF(A2 = 0,0,IF(A2 < B2,B2 - A2,NA())))

AmtChargable = A2
Potenial = B2

 

[dazoloko via OfficeKB.com]

Thank you all who responded, mission accomplished !!

D

=IF(A2 > B2, B2,IF(A2 = 0,0,IF(A2 < B2,B2 - A2,NA())))

AmtChargable = A2
Potenial = B2

Dear All

[quoted text clipped - 20 lines]

D