View Single Post
  #7   Report Post  
David Biddulph
 
Posts: n/a
Default calculating different percentages depending on amount

"goober" wrote in
message ...

Here's one which may work. Just substitute A1 with the cell your
information is in.

=IF(A1<=41100,A1*.045,(A1*.05)+((A1-41100)*.06))


Or did you mean:
=IF(A1<=41100,A1*.045,(A1*.045)+((A1-41100)*.06)) ?
--
David Biddulph