| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Changing display of decimal value based on the value in the cell
If the numeric value in the cell is less than or equal to 5 I would like the
number to be displayed with one decimal value. If in the same cell the value is 5 I would like the number to be displayed with 0 decimal places. The cell I am talking about is itself composed of ROUND function. How can this be done? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Format a cell to display decimal hours. | Excel Discussion (Misc queries) | |||
| Display message based on condition | Excel Worksheet Functions | |||
| Sub-Totalling Based upon a changing field | Excel Worksheet Functions | |||
| changing value of a cell based on another cell color | Excel Discussion (Misc queries) | |||
| Combine & Display “Fixed” & “Automatically Updated” Date Parts | Excel Worksheet Functions | |||
Threaded Mode
