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