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




wrote in message
ups.com...
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?