Writing formulae - theoretical

marstonk

Active Member
Joined
Jan 30, 2003
Messages
273
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
 

Some videos you may like

Excel Facts

How to calculate loan payments in Excel?
Use the PMT function: =PMT(5%/12,60,-25000) is for a $25,000 loan, 5% annual interest, 60 month loan.

S.H.A.D.O.

Well-known Member
Joined
Sep 6, 2005
Messages
1,915
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

Active Member
Joined
Jan 30, 2003
Messages
273
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

Well-known Member
Joined
Jul 17, 2004
Messages
2,838

ADVERTISEMENT

If you press control + ~

All formulas will be displayed.
 

iggydarsa

Well-known Member
Joined
Jun 28, 2005
Messages
1,647
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

Active Member
Joined
Jan 30, 2003
Messages
273

ADVERTISEMENT

Where can I find this equation menu?

Exactly what I mean thanks

kitty
 

iggydarsa

Well-known Member
Joined
Jun 28, 2005
Messages
1,647
-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

Active Member
Joined
Jan 30, 2003
Messages
273
Thanks so much - it is a shame you cannot have this toolbar ability in excel too. Oh well.

Thanks
Again

kitty
 

Watch MrExcel Video

Forum statistics

Threads
1,118,088
Messages
5,570,147
Members
412,306
Latest member
fabio6
Top