Hi All,

It's been a while, good to be using excel again.

I need a formula to calculate cell A1

Cell A1 is to be used to enter an amount by a user

Then I need to multiply cell A1 by 3% if less than or equal to 45000. But,
if the cell amount goes over 45000 I need then to calculate up to 45000 by 3%
and the amount over 45000 by 5%, and have the result in one cell

0-45000 multiply by 3%
45001 multiply by 5%

Thank you all in advance
--
Lost in office 2007