Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Spread Sheet Help again
Here it is hope someone can help me out one more time? I sell something for $25.00 or lower the fee is 5.25% ($1.31), But if its more $25.01 to $1,000.00 fee is 5.25% of the initial $25.00 ($1.31), plus 2.75% ($0.68)of the remaining closing value balance ($25.01 to $1,000.00) Cell H1 is $25.00 then Cell J1 is $1.31 (5.25%) Cell H1 is $25.01 then Cell J1 is $1.31 (5.25%)plus 2.75% or $1.99 Can I have them in the same cell somehow is this possable? Thanks for the help -- califman1961 ------------------------------------------------------------------------ califman1961's Profile: http://www.excelforum.com/member.php...o&userid=19783 View this thread: http://www.excelforum.com/showthread...hreadid=346871 |
#2
|
|||
|
|||
One way:
=ROUND(SUMPRODUCT(--(H1{0,25}),(H1-{0,25}),{0.0525,-0.025}),2) See http://www.mcgimpsey.com/excel/variablerate.html for an explanation of the formula, and a way to extend it beyond $1,000. In article , califman1961 wrote: Here it is hope someone can help me out one more time? I sell something for $25.00 or lower the fee is 5.25% ($1.31), But if its more $25.01 to $1,000.00 fee is 5.25% of the initial $25.00 ($1.31), plus 2.75% ($0.68)of the remaining closing value balance ($25.01 to $1,000.00) Cell H1 is $25.00 then Cell J1 is $1.31 (5.25%) Cell H1 is $25.01 then Cell J1 is $1.31 (5.25%)plus 2.75% or $1.99 Can I have them in the same cell somehow is this possable? Thanks for the help |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
in excel, how do i set up a spread sheet that automatically total. | New Users to Excel | |||
How do I set up a spread sheet to calculate pay rates for teacher. | Setting up and Configuration of Excel | |||
How do I get the top 4 rows of a spread sheet to print on each pa. | Excel Discussion (Misc queries) | |||
How do I get rid of spare lines in an excel spread sheet? | Excel Worksheet Functions | |||
Naming & renaming a sheet tab | Excel Worksheet Functions |