Hi Jill

Are you sure about your required result:

$795 - $25 = $770 * 2.75% = $21.18
$25 * 5.25% = $1.31

So as you have explained the percentage breakdowns $795 returns $22.49
which is what I get with your current formula.

Regards
Rowan

Jill24 wrote:
I should mention that I want to get the formula to give me $40.50 when S is
$795.00. Thanks.

"Jill24" wrote: