m2 after a sum equation

Johnny_Naughts · Apr 10th, 2002, 05:36 AM

Please can u assist. I require a "m2" to appear after my equation total in the same cell. Is this possible

Aladin Akyurek · Apr 10th, 2002, 05:43 AM

Quote:

On 2002-04-10 04:36, Johnny_Naughts wrote:
Please can u assist. I require a "m2" to appear after my equation total in the same cell. Is this possible

Change your formula to:

=your-formula&" m2"

paludgnp · Apr 10th, 2002, 05:48 AM

Yes, it is possible, but your cell will become text and therefore can't be summed (e.g.) later with another one without removing the m2)

If in Cell(1,2) you want to have the result of Cell (1,1) + m2, write the code as follows:
=C1 & " m2"
The '&' concatenate one string with another. Your first string is determined by the result of C1 and second is enabled by the ' " ' text operator.
good luck

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Apr 10th, 2002, 05:36 AM	#1
Johnny_Naughts New Member Join Date: Apr 2002 Location: Manchester Posts: 1	Please can u assist. I require a "m2" to appear after my equation total in the same cell. Is this possible

Apr 10th, 2002, 05:48 AM	#3
paludgnp New Member Join Date: Feb 2002 Location: Belgium Posts: 24	Yes, it is possible, but your cell will become text and therefore can't be summed (e.g.) later with another one without removing the m2) If in Cell(1,2) you want to have the result of Cell (1,1) + m2, write the code as follows: =C1 & " m2" The '&' concatenate one string with another. Your first string is determined by the result of C1 and second is enabled by the ' " ' text operator. good luck