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

AmtChargable = A2
Potenial = B2
--
HTH,
Barb Reinhardt



"dazoloko via OfficeKB.com" wrote:

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

--
Message posted via http://www.officekb.com