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
|