| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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! |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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! |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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! |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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! |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 - |
|
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 - |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Hybrid Mode
