CyndiP,

With X in cell A1, use the formula

=MIN(25,A1)*8%+MIN(975,MAX(0,A1-25))*5%+MAX(0,(A1-1000))*3%

HTH,
Bernie
MS Excel MVP


"CyndiP" wrote in
message ...

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