Maybe a series of IF instructions would work. I can't write the formula for
you, but you would need three strings:

If value in G6 is .01<25, the output is G6 times .0525
If value is G6 is 25<1000, output is 1.3125 plus (G6-25) times .0275
If value in G6 is 1000, output is 1.3125 plus 26.8125 plus (G6-1000) times
..015

"clandis" wrote in
message ...

If someone could offer a solution on a percentage formula based on the
table below I would greatly appreciate it:

if the value in cell G6 is $00.01 - $25.00, the percentage is 5.25%
if the value in cell G6 is $25.01 - $1000.00, the percentage is 2.75%
if the value in cell G6 is $1000.01 and greater, the percentage is
1.50%

For example, if I have a value of $1,255.00 in cell G6, I need to
calculate the first $25.00 at 5.25%, $975 at 2.75% and the remainder of
$255.00 at 1.50% added together and output a value in G7.

Doing this manually, i end up with $31.95 in cell G7 ($1.3125 +
$26.8125 + $3.825)

Help


--
clandis
------------------------------------------------------------------------
clandis's Profile:
http://www.excelforum.com/member.php...o&userid=25468
View this thread: http://www.excelforum.com/showthread...hreadid=389079