| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
If..display "0", if greater than... display actual
If value in cell a1 = 1 through 149, display "0" in a2
If vallue in cell a1 = 150 or greater, display actual value of a1, in cell a2 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How can I display my "false" value as an actual value? | Excel Worksheet Functions | |||
| Matching Values from an Array | Excel Worksheet Functions | |||
| display actual number or zero, whichever is greater | Excel Discussion (Misc queries) | |||
| Actual value a non-zero number but display is Zero | Excel Discussion (Misc queries) | |||
| Display a row if a cell value is greater than zero | Excel Worksheet Functions | |||
Threaded Mode
