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
|