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

Format cells as currency
Select range and press Ctrl+Shift+4 to format cells as currency. (Shift 4 is the $ sign).

iggydarsa

Well-known Member
Joined
Jun 28, 2005
Messages
1,649
Office Version
  1. 2019
Platform
  1. Windows
try to put ' (single quote) before the formula
 

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
If you press control + ~

All formulas will be displayed.
 

iggydarsa

Well-known Member
Joined
Jun 28, 2005
Messages
1,649
Office Version
  1. 2019
Platform
  1. Windows
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
Where can I find this equation menu?

Exactly what I mean thanks

kitty
 

iggydarsa

Well-known Member
Joined
Jun 28, 2005
Messages
1,649
Office Version
  1. 2019
Platform
  1. Windows
-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
 

Forum statistics

Threads
1,171,651
Messages
5,876,694
Members
433,205
Latest member
jabin1991

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