If Then Formula

RAL · Jan 11, 2009

What is the If then formula? I want to take 60% of a number in a cell "If" it
is greater "than" 500. If it is not, "then" I want the 60% cell zero. I
cannot figure it out.
Help!

FSt1 · Jan 11, 2009

hi
something like this....
=IF(B2>500,B2*0.6,0)

adjust to suit
regards
FSt1

Per Jessen · Jan 11, 2009

Hi

With your number in A1, if it's > 500 then the result is 500*60% else
the result is zero.

Try this:

=IF(A1>500,A1*0.6,0)

Regards, Per

RAL · Jan 12, 2009

This worked! Now for a litttle more complicated formula. What I now need is
60% of any money OVER $500. So if the number is $501, then 60% of $1.00 is 60
cents. Help me Per!
RAL

Per Jessen · Jan 12, 2009

No problem:

=IF(A1>500,(A1-500)*0.6,0)

Best regards,
Per

RAL · Jan 12, 2009

Thank you!

Per Jessen said:
No problem:

=IF(A1>500,(A1-500)*0.6,0)

Best regards,
Per