help with formula

J

Jill24

$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!
 
J

Jill24

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

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
 
D

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)
 
J

Jill24

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!
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top