This is realy simple to most but I'm struggling with it.

I have a column in an excel spreadsheet with numbers as follows:

0.99
1.04
1.03
1.04
1.04

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?

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