On Sun, 16 Mar 2008 10:58:16 +0000, "Keith (Southend)"
wrote:

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

Assuming the data is in column A, then something like

=IF(A11,0,1)


The if function works like this

IF(logical_test,value_if_true,value_if_false)

So for the example above it effectively says

If Cell A1 is less than 1, then make the value 0, otherwise make it 1

HTH

Noz