IF Function with different ranges.

[GEM]

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

 

[Luke M]

Try this:

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