Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Help with formula
There is a charge of £55.75, to which a handling fee of 2.95% is to be
added. But, the handling fee is also capped at £0.50 minimum and £1.50 maximum. Any help as to the correct formula for calculating the fee will be much appreciated - I am stumped. -- Kind regards, Trevor Bloomer |
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Help with formula
Trevor,
With the charge (in this case, 55.75) in cell A2, the formula =MAX(0.5,MIN(A2*.0295,1.5)) will return the correct fee. HTH, Bernie MS Excel MVP "Trevor Bloomer" wrote in message ... There is a charge of £55.75, to which a handling fee of 2.95% is to be added. But, the handling fee is also capped at £0.50 minimum and £1.50 maximum. Any help as to the correct formula for calculating the fee will be much appreciated - I am stumped. -- Kind regards, Trevor Bloomer |
#3
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Help with formula
Bernie, thank you so much - that's great.
Trevor "Bernie Deitrick" <deitbe @ consumer dot org wrote in message ... Trevor, With the charge (in this case, 55.75) in cell A2, the formula =MAX(0.5,MIN(A2*.0295,1.5)) will return the correct fee. HTH, Bernie MS Excel MVP "Trevor Bloomer" wrote in message ... There is a charge of £55.75, to which a handling fee of 2.95% is to be added. But, the handling fee is also capped at £0.50 minimum and £1.50 maximum. Any help as to the correct formula for calculating the fee will be much appreciated - I am stumped. -- Kind regards, Trevor Bloomer |
#4
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Help with formula
Try this:
=IF(A1<=16.95,0.5,ROUND(MIN(A1*0.0295,1.5),2)) -- Biff Microsoft Excel MVP "Trevor Bloomer" wrote in message ... There is a charge of £55.75, to which a handling fee of 2.95% is to be added. But, the handling fee is also capped at £0.50 minimum and £1.50 maximum. Any help as to the correct formula for calculating the fee will be much appreciated - I am stumped. -- Kind regards, Trevor Bloomer |
#5
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Help with formula
Hi Trevor
With your amount in A1, try =MIN(1.5,MAX(0.5,A1*2.9%)) -- Regards Roger Govier "Trevor Bloomer" wrote in message ... There is a charge of £55.75, to which a handling fee of 2.95% is to be added. But, the handling fee is also capped at £0.50 minimum and £1.50 maximum. Any help as to the correct formula for calculating the fee will be much appreciated - I am stumped. -- Kind regards, Trevor Bloomer |
#6
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Help with formula
Thanks to you all for your help.
-- Kind regards, Trevor Bloomer "Trevor Bloomer" wrote in message ... There is a charge of £55.75, to which a handling fee of 2.95% is to be added. But, the handling fee is also capped at £0.50 minimum and £1.50 maximum. Any help as to the correct formula for calculating the fee will be much appreciated - I am stumped. -- Kind regards, Trevor Bloomer |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|