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
 

Excel Facts

Enter current date or time
Ctrl+: enters current time. Ctrl+; enters current date. Use Ctrl+: Ctrl+; Enter for current date & time.

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
 
Master Excel Bundle

Excel contains over 450 functions, with more added every year. That’s a huge number, so where should you start? Right here with this bundle.

Forum statistics

Threads
1,168,120
Messages
5,857,494
Members
431,882
Latest member
saaaaaaaaaaaaaaaaaaaaaa

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top