Thread
:
Changing display of decimal value based on the value in the cell
View Single Post
#
1
Ragdyer
Posts: n/a
Try custom format:
[<=5]###.0;[5]###;General
--
HTH,
RD
---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"K M" <K
wrote in message
...
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?
Reply With Quote