# Thread: IF Formulas

1. ## IF Formulas

Having a little trouble with an IF formula.

Column A1 = \$1050

In Column A2 I want it to say, if A1<1000 = 0, if A1>1000 then enter the value from A1
So in this example the answere in A2 would be \$1050

IF(A1<1000,"0",????

2. Hi sumsum, and welcome to the forum.

Try this: =IF(A1<1000,0,A1)

3. Thanks Ken.

So happy to find this forum, what a great resource.

4. Just because I like no-IF formulas

=A1*(A1>=1000)

5. Sumsum: you should also check out http://www.excelhero.com/blog/2010/01/i-heart-if.html for some more background on IF as well as some alternatives. Such as
Code:
`=A1*(A1>=1000)`
which basically says
multiply A1 by one if A1 >= 1000, otherwise multiply A1 by zero
. The part (A1>=1000) is an example of boolean logic: it returns "True" if true and "FALSE" if false. When Multiplying a "TRUE" or "FALSE" with something (in this case, A1), Excel turns a TRUE into 1 and a FALSE into zero.

The 2 reasons you might want to do this is that (1) using boolean logic is much less processer intensive than using IF, and (2) it makes other excel nerds excited.

6. Originally Posted by JeffreyWeir
The 2 reasons you might want to do this is that (1) using boolean logic is much less processer intensive than using IF
I doubt most users would notice the effects of this unless they had thousands of these calls in their spreadsheets. (And possibly tens of thousands.)

Originally Posted by JefferyWeir
, and (2) it makes other excel nerds excited.
Now that's an EXCELLENT reason though!

7. Originally Posted by Ken Puls
I doubt most users would notice the effects of this unless they had thousands of these calls in their spreadsheets. (And possibly tens of thousands.)
And if they do, it will be so slow they won't notice the difference anyway.

#### Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts
•