=MIN(25,G6)*5.25%+(MIN(975,G6-25)*2.75%)*(G6>25)+MAX(0,G6-1000)*1.5%


"clandis" <clandis.1sj1r1_1121962188.4416@excelforum-nospam.com> wrote in
message news:clandis.1sj1r1_1121962188.4416@excelforum-nospam.com...
>
> 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
>