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
|