Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Excel Formula
I came across a cell with the following formula -
='August 31 final'!N5 Can someone please tell me what this formula means? |
#2
|
|||
|
|||
Excel Formula
Hi
It looks as as though there is a sheet called 'August 31 final' and the formula is picking up the value that is contained in cell N5 of that sheet. Regards Roger Govier windsong wrote: I came across a cell with the following formula - ='August 31 final'!N5 Can someone please tell me what this formula means? |
#3
|
|||
|
|||
Excel Formula
It means that it gets its value from the cell N5 on a worksheet called
'August 31 final'. The worksheet name does not include the quotes, they are required as the worksheet name has embedded spaces. -- HTH RP (remove nothere from the email address if mailing direct) "windsong" wrote in message ... I came across a cell with the following formula - ='August 31 final'!N5 Can someone please tell me what this formula means? |
#4
|
|||
|
|||
Excel Formula
Thank you. Now I have a follow-on question.
This formula occurs in one column, but not on every line - it is on every other line, e.g. ='August 31 final'!N5 ='August 31 final'!N7 ='August 31 final'!N9 How do you get a formula to appear on every other line like this? I thought they had to show on every line. Also, I need to delete one of the lines but don't want it to interfere with the formula. How can I delete it safely? I know the formula usually changes itself when there is an addition or deletion to rows but in this case I need the formula to NOT adjust itself. "Roger Govier" wrote: Hi It looks as as though there is a sheet called 'August 31 final' and the formula is picking up the value that is contained in cell N5 of that sheet. Regards Roger Govier windsong wrote: I came across a cell with the following formula - ='August 31 final'!N5 Can someone please tell me what this formula means? |
#5
|
|||
|
|||
Excel Formula
By the way what sort of formula is this? I don 't believe it is a conditional formula but I don't know what other kind there is. I ask so I know what to look up in the Excel manual that I have. Thanks. "Roger Govier" wrote: Hi It looks as as though there is a sheet called 'August 31 final' and the formula is picking up the value that is contained in cell N5 of that sheet. Regards Roger Govier windsong wrote: I came across a cell with the following formula - ='August 31 final'!N5 Can someone please tell me what this formula means? |
#6
|
|||
|
|||
Excel Formula
Terrific! Thank you. "Bob Phillips" wrote: It means that it gets its value from the cell N5 on a worksheet called 'August 31 final'. The worksheet name does not include the quotes, they are required as the worksheet name has embedded spaces. -- HTH RP (remove nothere from the email address if mailing direct) "windsong" wrote in message ... I came across a cell with the following formula - ='August 31 final'!N5 Can someone please tell me what this formula means? |
#7
|
|||
|
|||
Excel Formula
Also, I need to delete one of the lines but don't want it to interfere with
the formula. How can I delete it safely? I know the formula usually changes itself when there is an addition or deletion to rows but in this case I need the formula to NOT adjust itself. "windsong" wrote: Terrific! Thank you. "Bob Phillips" wrote: It means that it gets its value from the cell N5 on a worksheet called 'August 31 final'. The worksheet name does not include the quotes, they are required as the worksheet name has embedded spaces. -- HTH RP (remove nothere from the email address if mailing direct) "windsong" wrote in message ... I came across a cell with the following formula - ='August 31 final'!N5 Can someone please tell me what this formula means? |
#8
|
|||
|
|||
Excel Formula
Just change it back afterwards.
-- HTH RP (remove nothere from the email address if mailing direct) "windsong" wrote in message ... Also, I need to delete one of the lines but don't want it to interfere with the formula. How can I delete it safely? I know the formula usually changes itself when there is an addition or deletion to rows but in this case I need the formula to NOT adjust itself. "windsong" wrote: Terrific! Thank you. "Bob Phillips" wrote: It means that it gets its value from the cell N5 on a worksheet called 'August 31 final'. The worksheet name does not include the quotes, they are required as the worksheet name has embedded spaces. -- HTH RP (remove nothere from the email address if mailing direct) "windsong" wrote in message ... I came across a cell with the following formula - ='August 31 final'!N5 Can someone please tell me what this formula means? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Why does Excel show a formula in ONE cell ? | Excel Discussion (Misc queries) | |||
Excel CHALLENGE...3 questions(indirect,rank,array formula)... | Excel Worksheet Functions | |||
converting formula from lotus.123 to excel | Excel Worksheet Functions | |||
How do I get the formula bar in excel 2003 | Excel Discussion (Misc queries) | |||
Suddenly Excel can't calculate formula!!! | Excel Worksheet Functions |