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


Never used excel but int(cell) should work (it does in open office calc).


--
Brian Wakem