If And Calcuation

[Guest]

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

 

[Bob Phillips]

=A1*3%+(MAX(A1-45000,0))*2%

--
---
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)

 

[Alan]

=IF(A1<=45000,A1*1.03,IF(A1>45000,A1*1.05))
Regards,
Alan.

 

[Guest]

Bob, your a star!!!! Thanks a bunch

 

[Guest]

=MIN(45000,A1)*3%+MAX(A1-45000,0)*5%