$ in formula

[CCHRdept]

What does a $ sign in a formula mean? For example, $45$+$78$

 

[Brian from Maui]

When you copy or move the formula, it will always reference those cells. Absolute cell reference.

 

[lenze]

See the help index for Absolute and Relative Cell references

 

[Mark W.]

On 2002-04-26 09:40, CCHRdept wrote:
What does a $ sign in a formula mean? For example, $45$+$78$

$ signs are used to construct absolute and mixed references. Actually, $45$+$78$, is nonsensical. However, $45:$45, would be an absolute reference to row 45. When you're copying and pasting formulas on a worksheet $ signs behave as though they were anchors.

For more, see the Excel Help Index topic for "The difference between relative and absolute references".
This message was edited by Mark W. on 2002-04-26 09:49