Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Need Help with a formula
I am stumped on a formula... if ANY one can help me - please post!!! Here is what i am trying to do: Item sells at X Amount If X amount is between $.01 - $25 then take 8% of that number = ? If X amount is between $25.01 - $1000 then take 8% of the $.01 - $25 then 5% of the remaining = ? If X amount is over $1000.01 then take 8% of the $.01 - $25, 5% of the $25.01 - $1000 then 3% for the remaining = ? The final number would be a percentage based off of the above. IE - If I sell an item at $18 - the number showing should be $1.44IE - (8% of the 18) IE - If I sell an item at $500 - the number showing should be $25.75 - (8% of the $25 = $2. automatically, then 5% of the $475) PLEASE HELP - I AM STUCK ON A WORK PROJECT!! -- CyndiP ------------------------------------------------------------------------ CyndiP's Profile: http://www.excelforum.com/member.php...o&userid=27941 View this thread: http://www.excelforum.com/showthread...hreadid=474415 |
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) |