adding text to a formula

This question was asked and responded hundreds of times 😟

Search for the keyword IEEE in existing threads.

There is one thread about this question in the late 90 days.

I will just write that when you format a cell with 0 decimal, you don't change its contents but the way it appears.
the range 0.500000000000001 thru 1.499999999999999
will be displayed as 1



Yvan KOENIG (VALLAURIS, France) samedi 27 mars 2010 19:14:09

If you want it truncated or rounded, you have to put that in the formula. That is true for what you are trying to do here and it is true for everything else, too. You may have the cell formatted to show a certain number of decimal places but that is just for display, all the decimals are still there.

="pi rounded to 2 decimals is "&ROUND(PI(),2)

To get a quote in your string, you need to use two of them together. If you want a quote at the beginning or end or your string, that would require three quotes in a row.

="They said ""Have a nice day"""

Yvan is pointing out another thing that people find odd. Computers don't use base 10 arithmetic so sometimes there is a very very slight error in some calculations as compared to what you would get if you did it on a piece of paper. It is all in accordance with the IEEE standard, not a bug.

Here is an example

="2+4 = "&SUM(2,4)

or

=SUM(2,4)&" is the sum of 2 and 4"