If And Calcuation
 

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

If And Calcuation
 

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

--
---
HTH

Bob

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



"Kimbo" wrote in message
...
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

If And Calcuation
 

=IF(A1<=45000,A1*1.03,IF(A145000,A1*1.05))
Regards,
Alan.
"Kimbo" wrote in message
...
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

If And Calcuation
 

Bob, your a star!!!! Thanks a bunch
--
Lost in office 2007


"Bob Phillips" wrote:

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

--
---
HTH

Bob

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



"Kimbo" wrote in message
...
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

If And Calcuation
 

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


"Kimbo" wrote:

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