I'm trying to convert an excel formula that I found to a more easily understood formula. Below is the formula I'm trying to interpret. What is ei??
=3*ei/2-27*ei^3/32
+1
A:
It refers to a cell named ei. When you paste this formula into Excel, it probably gives you the error #NAME? meaning there is no cell named ei You can either replace each ei in your formula to a cell reference or go to a cell and name it ei and put the value in there. Named cells are the same, but easier to read, form of absolute reference as Sheet2!$C$4 for example.
drewk
2010-04-20 21:38:19
how can I find that cell? edit>find didn't help
Josh
2010-04-20 21:39:00
In good old Excel 97 you used to be able to define cell names via menu item `Insert -> Names -> Define...`.
stakx
2010-04-20 21:41:40
I'm using excel 2003. Any ideas how I can find which cell is ei?
Josh
2010-04-20 21:43:11
I think in all versions of Excel I remember it is the pull down / scroll dohiche left of the formula bar that usually just has `b6` or whatever cell you are in. Highlight `b6` (or whatever current cell reference) to the current cell and type `ei` Know though that named cells are absolute so if you autofill your reference will not increment the same as a relative reference of the form `b6`
drewk
2010-04-20 21:49:13
To find a named cell, use `Edit -> Go To...`
drewk
2010-04-20 21:52:05
+2
A:
In the 'Name Box', in the upper left part of your Excel screen, type ei and hit enter. This will take you right to cell ei. The 'Name Box' is that little address box that shows you what cell address you are currently in.
If ei is actually the name of a cell, it will take you right to that cell. If ei is not the name of a cell, typing ei in the 'Name Box' and hitting enter will give the name ei to the cell you are currently in.
You can also use the dropdown arrow for the 'Name Box' to see a list of all the named ranges and cells in the workbook.
Stewbob
2010-04-21 01:13:42