 |
|
| uk.sci.weather (UK Weather) (uk.sci.weather) For the discussion of daily weather events, chiefly affecting the UK and adjacent parts of Europe, both past and predicted. The discussion is open to all, but contributions on a practical scientific level are encouraged. |
|
|
LinkBack | Thread Tools | Display Modes |
|
#1
March 16th 08, 09:58 AM
posted to uk.sci.weather
|
|||
|
|||
[OT] Excel help
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 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Excel template for recording daily local weather. | uk.sci.weather (UK Weather) | |||
| (OT) Excel help | uk.sci.weather (UK Weather) | |||
| OT Excel ? | uk.sci.weather (UK Weather) | |||
| O/T Excel Help | uk.sci.weather (UK Weather) | |||
| Excel help :-) | uk.sci.weather (UK Weather) | |||
Threaded Mode
