I would like for A1 to be my closing value and for A2 to give me the exact
total I would be charged for the following...

$0.01 - $25.00 --- 8.75% of the closing value

$25.01- $1,000.00 --- 8.75% of the initial $25.00, plus 3.50% of the
remaining closing value balance

Equal to or Over $1000.01 ---- 8.75% of the initial $25.00, plus 3.50% of
the initial $25.01 - $1,000.00, plus 1.50% of the remaining closing value
balance

Try this:

=MIN(25,A1)*8.75%+MIN(975,MAX(0,A1-25))*3.5%+MAX(A1-1000,0)*1.5%
--
Best Regards,

Luke M
*Remember to click "yes" if this post helped you!*


"GEM" wrote:

I would like for A1 to be my closing value and for A2 to give me the exact
total I would be charged for the following...

$0.01 - $25.00 --- 8.75% of the closing value

$25.01- $1,000.00 --- 8.75% of the initial $25.00, plus 3.50% of the
remaining closing value balance

Equal to or Over $1000.01 ---- 8.75% of the initial $25.00, plus 3.50% of
the initial $25.01 - $1,000.00, plus 1.50% of the remaining closing value
balance