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

Can you AutoAverage in Excel?
There is a drop-down next to the AutoSum symbol. Open the drop-down to choose AVERAGE, COUNT, MAX, or MIN
try to put ' (single quote) before the formula
 
Upvote 0
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
 
Upvote 0
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?
 
Upvote 0
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
 
Upvote 0
-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
 
Upvote 0
Thanks so much - it is a shame you cannot have this toolbar ability in excel too. Oh well.

Thanks
Again

kitty
 
Upvote 0

Forum statistics

Threads
1,214,915
Messages
6,122,217
Members
449,074
Latest member
cancansova

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
Back
Top