Wed 17 Sep 2008, 16:08Delegate Liz said...
Liz has attended:
SharePoint course
Units in function cells
Hello
We have a column of numbers totalled using the SUM function.
We want the total to have the unit (m2) after the number, in the same cell. How can we do this please?
thanks
Thu 18 Sep 2008, 09:58Trainer Amanda said...
RE: units in function cells
Hi Liz
Thank you for your question.
Say your SUM function is adding together cells D7 to D9, then the formula to add m2 onto the end of the formula result will look like this:
=SUM(D7:D9)&" m2"
which will display the formula result followed by a space and then m2
If you don't want the space between the result and the m2 then use
=SUM(D7:D9)&"m2"
I hope this helps.
Amanda
