If And Calcuation

K

Kimbo

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
 
B

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