Formula
 

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

Formula
 

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))

"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

Formula
 

=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

Formula
 

Thank you all who responded, mission accomplished !!

D


Barb Reinhardt wrote:
=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

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