Spread Sheet Help again

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

califman1961 - 18 Feb 2005 18:35 GMT

Here it is hope someone can help me out one more time?

I sell something for $25.00 or lower the fee is 5.25% ($1.31), But if
its more $25.01 to $1,000.00 fee is 5.25% of the initial $25.00
($1.31), plus 2.75% ($0.68)of the remaining closing value balance
($25.01 to $1,000.00)

Cell H1 is $25.00 then Cell J1 is $1.31 (5.25%)
Cell H1 is $25.01 then Cell J1 is $1.31 (5.25%)plus 2.75% or $1.99
Can I have them in the same cell somehow is this possable?
Thanks for the help

Signature

califman1961

Reply to this Message

JE McGimpsey - 18 Feb 2005 21:00 GMT

One way:

=ROUND(SUMPRODUCT(--(H1>{0,25}),(H1-{0,25}),{0.0525,-0.025}),2)

See

http://www.mcgimpsey.com/excel/variablerate.html

for an explanation of the formula, and a way to extend it beyond $1,000.

> Here it is hope someone can help me out one more time?
>
[quoted text clipped - 7 lines]
> Can I have them in the same cell somehow is this possable?
> Thanks for the help

Reply to this Message