Excel Formula

W

windsong

I came across a cell with the following formula -

='August 31 final'!N5

Can someone please tell me what this formula means?
 
R

Roger Govier

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
 
B

Bob Phillips

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)
 
W

windsong

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.
 
W

windsong

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.
 
W

windsong

Terrific! Thank you.

Bob Phillips said:
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)
Click to expand...
 
W

windsong

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.
 
B

Bob Phillips

Just change it back afterwards.

--

HTH

RP
(remove nothere from the email address if mailing direct)
 
Top