How to display zero in a number to 1dp e.g. 14.0 without stripping the zero

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?
 
P

Peo Sjoblom

I don't understand what the first part is

=""

it doesn't do anything, if you want text use the text function

=IF(B3="","",IF(ISNUMBER(B3),TEXT(ROUND(100*B3,1),"0.0"),B3))


--


Regards,


Peo Sjoblom
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Help using the DAY() function 8
#VALUE error add'g formulas 1
display zero values at the beginning of a number. 2
Excel In Excel how can I block the contenent of a cell? 0
reset value back to zero 2
How can i change the #N/A error for a 0 value 2
Setting number in cell back to zero 2
Finding NEXT to last, non zero numeric value in a row 3

Top