If Then Formula
 

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!

If Then Formula
 

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

adjust to suit
regards
FSt1

"RAL" wrote:

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!

If Then Formula
 

Hi

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

Try this:

=IF(A1500,A1*0.6,0)

Regards, Per

On 12 Jan., 00:28, RAL wrote:
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!

If Then Formula
 

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" wrote:

Hi

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

Try this:

=IF(A1500,A1*0.6,0)

Regards, Per

On 12 Jan., 00:28, RAL wrote:
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!

If Then Formula
 

No problem:

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

Best regards,
Per

On 12 Jan., 01:36, RAL wrote:
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" wrote:
Hi

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

Try this:

=IF(A1500,A1*0.6,0)

Regards, Per

On 12 Jan., 00:28, RAL wrote:
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!- Skjul tekst i anførselstegn -

- Vis tekst i anførselstegn -

If Then Formula
 

Thank you!

"Per Jessen" wrote:

No problem:

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

Best regards,
Per

On 12 Jan., 01:36, RAL wrote:
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" wrote:
Hi

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

Try this:

=IF(A1500,A1*0.6,0)

Regards, Per

On 12 Jan., 00:28, RAL wrote:
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!- Skjul tekst i anførselstegn -

- Vis tekst i anførselstegn -