If/and functions

[Guest]

I have a number of values in column A ranging from 0-2.3. I'd like to create
a formula that will place a 1 in column B for those values greater than or
equal to 0.18, or a 0 for those values less than .18. Any help you all could
provide would be greatly appreciated!

JR

 

[Guest]

Try the following formula:

=IF(A1>=.18,1,0)

 

[Otto Moehrbach]

Try this. Put this formula in B1 and drag it down as far as the Column A
data goes. HTH Otto
=If(A1>=.18,1,0)

 

[Guest]

Put this in B1 and copy down where needed
=IF(A1>=0.18,1,0)

 

[Rick Rothstein \(MVP - VB\)]

Just to be different form the rest<g>, put this in A1 and copy down...

=ABS(A1>=0.18)

Rick

 

[Rick Rothstein \(MVP - VB\)]

=ABS(A1>=0.18)

Actually, I'm not sure why I chose to use the ABS function; this should be
quicker (because it doesn't use a function call at all)...

=--(A1>=0.18)

Note: There are two minus signs in front of the left parenthesis.

Rick