S
sjharri
I have the following formula in a cell:
="" & IF(B3="","",IF(ISNUMBER(B3),ROUND(100*B3,1),B3)), it is reading
the value 13.96% (cell B3). The displayed value is being rounded to
one decimal place, i.e. 14.0, however, the actual value being
displayed is 14, the '.0' is being stripped. How can I force it to
display the '.0'? I have tried using the TEXT function but wherever I
put it in the above formula it give me an error.
Any ideas?
="" & IF(B3="","",IF(ISNUMBER(B3),ROUND(100*B3,1),B3)), it is reading
the value 13.96% (cell B3). The displayed value is being rounded to
one decimal place, i.e. 14.0, however, the actual value being
displayed is 14, the '.0' is being stripped. How can I force it to
display the '.0'? I have tried using the TEXT function but wherever I
put it in the above formula it give me an error.
Any ideas?