If Then Formula

[RAL]

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]

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

adjust to suit
regards
FSt1

 

[Per Jessen]

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]

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]

No problem:

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

Best regards,
Per

 

[RAL]

Thank you!

No problem:

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

Best regards,
Per