Home |
Search |
Today's Posts |
#5
![]() |
|||
|
|||
![]()
A different approach
=SUM(--(A10)*316.25,--(A155000)*(INT(A1/1000-55)*5.75),--(A1100000)*(INT(A1/1000-100)*-0.75)) personal preference as to which you choose. This would be neater if you wish to increase the number of price brackets. hth RES It starts out at a flat fee of $316.25 for everything from 0 to $55,000.00, and then adds $5.75 per $1,000.00 up to a maximum of $100,000 and then anything over $100,000 the rate drops to $5.00 per $1,000 up to 1 million. What I am attempting to do is place a number like $250,000 in a box and have excel do the equation and automatically place $1,325.00 in another box. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
minimum a fixed figure when it is lower | New Users to Excel | |||
How can I make a timesheet to figure my hours and payrate? | Excel Worksheet Functions | |||
how to type a minues figure | New Users to Excel | |||
Function Help | Excel Worksheet Functions | |||
Amortization Schedule | Excel Worksheet Functions |