If/and functions
 

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

If/And functions
 

Try the following formula:

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

--
Kevin Backmann

If/and functions
 

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)
"JR-BHS" wrote in message
...
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

If/and functions
 

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

--
-John
Please rate when your question is answered to help us and others know what
is helpful.


"JR-BHS" wrote:

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

If/and functions
 

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

=ABS(A1=0.18)

Rick


"JR-BHS" wrote in message
...
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

If/and functions
 

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

=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