Steve Loft wrote:
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.

Wow, that was quick :-)

That does the job perfectly.

Many thanks

--
Keith (Southend)
http://www.southendweather.net
e-mail: kreh at southendweather dot net