Writing formulae - theoretical

[marstonk]

Hi,

I want to write a formula in excel - I don't want it to calculate an answer it will be there for reference only so when I print a page I want to clearly see the formula.

An example of a formula I want to enter is - Sum all the units so use a sigma sign with units written directly under the sigma sign and n written directly above. Does anyone know if this is possible in excel?

Thanks
Kitty

 

[iggydarsa]

try to put ' (single quote) before the formula

 

[S.H.A.D.O.]

Hi Kitty,

What you could do is put a ' before the Formula, this will show you the actual Formula string and NOT the resultant value.

Hope this Helps.
All the Best.
SHADO

 

[marstonk]

This doesn't answer what I need to do - Sigma will never show as it is not used in the cell when you are summing things even if you put ' .

This will work if you are just using a normal excel formula.

any other suggestions?

 

[PA HS Teacher]

If you press control + ~

All formulas will be displayed.

 

[iggydarsa]

I dont know if I understood you correctly but there is menu icon named equation editor you can write your sigma thingy there and copy/paste to excel

 

[marstonk]

Where can I find this equation menu?

Exactly what I mean thanks

kitty

 

[iggydarsa]

-RIght click on the menu (on Word)
-click on "customize" on the list
-click on "Command" tab on the new window
-choose "Insert" from the left frame
-choose "Equation Editor" from left frame and drag it somewhere on the toolbars you have

 

[marstonk]

Thanks so much - it is a shame you cannot have this toolbar ability in excel too. Oh well.

Thanks
Again

kitty