Excel Formula
 

I came across a cell with the following formula -

='August 31 final'!N5

Can someone please tell me what this formula means?

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?

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?

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?

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?

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?

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?

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?