help with formula

[Guest]

$40.50 when S is $795.00 I need help figuring this formula out where am I
going wrong? I keep getting the wrong figures. This is the formula:
=IF(S118<=25, 0.0525*s118) + IF(AND(s118 >25, S118<=1000), 1.3125 +
0.0275*(S118 -25)) + IF(S118>1000, 28.125 + 0.015*(S118-1000))

Up to $25 will be charged 5.25% ,
5.25% of the initial $25.00 ($1.31), plus 2.75% of the remaining closing
value balance for $25.01 up to $1000,
over $1000.01 5.25% of the initial $25.00 ($1.31), plus 2.75% of the initial
$25.00 - $1,000.00 ($26.81), plus 1.50% of the remaining closing value
balance ($1,000.01 - closing value)

Thanks for any help!

 

[Guest]

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

 

[Rowan Drummond]

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

 

[Dana DeLouis]

Hi. I get the same answer as Rowan based on your definitions. (22.49)
Slightly different equation though...

=MIN(5.25%*S118, 2.75%*S118 + 0.625, 1.5%*S118 + 13.125)

 

[Guest]

Hi. I'm getting the same results. However I'm charged $40.50 and that fee
structure is how they charge. Maybe I'm being overcharged? Is there away to
change the forumula somehow to make it give me the figure $40.50 in the S
field?

Much appreciated!