probelm formating equations

  • Thread starter Thread starter kwstas
  • Start date Start date
K

kwstas

hi there!


is there a way for me to put an equation in a cell but beeig able to
see it?

for example : if i put this in a cell : " =C5+C8 " (C5 and C8 are cell
numbers which got in them values i.e 8 ,32 etc) will i be able to see
after pressing the enter button the "8+32=40" ( C5 has the value 8 and
C8 has 32) or "8+32"
instead of the value of "40" that i get so long?

thanks in advance for spending the time to cope with my problem ....



bye

kwstas.
 
You could use

= C5 & "+" & C8 & "=" & C5+C8

the downside of this is that the result is text and can't be used in
in follow-on calculations (but you can still use C5+C8).
 
kwstas said:
is there a way for me to put an equation in a cell but beeig able to
see it?

for example : if i put this in a cell : " =C5+C8 " (C5 and C8 are cell
numbers which got in them values i.e 8 ,32 etc) will i be able to see
after pressing the enter button the "8+32=40" ( C5 has the value 8 and
C8 has 32) or "8+32"
instead of the value of "40" that i get so long?
Click to expand...

If you select a cell containing an equation (for example, =C5+C8), the
equation appears in the formula bar (above the worksheet itself). If you
highlight C5 in this, and press F9, the value in C5 will be substituted
temporarily. Press ESC to get out of this mode. Likewise if you highlight C8
and press F9.
 
Back
Top