Home |
Search |
Today's Posts |
#1
|
|||
|
|||
help with formula
$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(S1181000, 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! |
#2
|
|||
|
|||
I should mention that I want to get the formula to give me $40.50 when S is
$795.00. Thanks. "Jill24" wrote: $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(S1181000, 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! |
#3
|
|||
|
|||
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: |
#4
|
|||
|
|||
=IF(S118<=25, 0.0525*s118) + IF(AND(s118 25, S118<=1000), 1.3125 +
0.0275*(S118 -25)) + IF(S1181000, 28.125 + 0.015*(S118-1000)) 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) -- Dana DeLouis Win XP & Office 2003 "Jill24" wrote in message ... I should mention that I want to get the formula to give me $40.50 when S is $795.00. Thanks. "Jill24" wrote: $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(S1181000, 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! |
#5
|
|||
|
|||
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! "Dana DeLouis" wrote: =IF(S118<=25, 0.0525*s118) + IF(AND(s118 25, S118<=1000), 1.3125 + 0.0275*(S118 -25)) + IF(S1181000, 28.125 + 0.015*(S118-1000)) 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) -- Dana DeLouis Win XP & Office 2003 "Jill24" wrote in message ... I should mention that I want to get the formula to give me $40.50 when S is $795.00. Thanks. "Jill24" wrote: $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(S1181000, 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! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
IF formula? | Excel Worksheet Functions | |||
writing a formula for a colored value | New Users to Excel | |||
referencing named formula using INDIRECT function | Excel Worksheet Functions | |||
Simplify formula | Excel Worksheet Functions | |||
Match / Vlookup within an Array formula | Excel Discussion (Misc queries) |