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