IF Function with different ranges.

  • Thread starter Thread starter GEM
  • Start date Start date
G

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
 
Back
Top