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

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

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

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

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

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