Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|