Keith (Southend) wrote:

What I want to show on the next column is either '0' or '1' depending on
whether the number is below 1 (0) or above 1 (1), wht formula can I put
in the column to the right of those numbers to produce that variable?

=IF(A11,0,1)

Checks whether A1 is less than 1, if it is it inserts the value after the
first comma, otherwise inserts the value after the second comma.
--
Steve Loft
Sanday, Orkney. 5m ASL. http://sanday.org.uk/weather
Free weather station softwa http://sandaysoft.com/
uk.sci.weather FAQs/glossary/etc: http://weatherfaqs.org.uk/