| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
What does the $ sign mean in spreadsheet calculations?
I am trying to construct a spreadsheet to calculate the amount of annual
leave due to people when they change their working habits throughout the year. I want to be able to show the person how the calculation has been arrived at and also want to be able to re-use the spreadsheet time and time again. I am using Excel 2003. Can you please help? Thank you. |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
What does the $ sign mean in spreadsheet calculations?
Your description doesn't relate to the question you asked as the title
for this thread, so I'm not sure what you want an answer for. The $ symbol is used to fix cell references so that either the row or column (or both) do not change when a formula is copied across or down - look in XL Help under Absolute referencing for further details. Hope this helps. Pete On Feb 17, 11:06*am, Charles. wrote: I am trying to construct a spreadsheet to calculate the amount of annual leave due to people when they change their working habits throughout the year. *I want to be able to show the person how the calculation has been arrived at and also want to be able to re-use the spreadsheet time and time again. *I am using Excel 2003. Can you please help? Thank you. |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
What does the $ sign mean in spreadsheet calculations?
The $ means that the cell reference is absolute rather than relative.
-- Gary''s Student - gsnu200834 "Charles." wrote: I am trying to construct a spreadsheet to calculate the amount of annual leave due to people when they change their working habits throughout the year. I want to be able to show the person how the calculation has been arrived at and also want to be able to re-use the spreadsheet time and time again. I am using Excel 2003. Can you please help? Thank you. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I digitally sign a cell in an excel spreadsheet? | Excel Worksheet Functions | |||
| Can I enter a tick sign in a spreadsheet cell somehow? | Excel Discussion (Misc queries) | |||
| why are the calculations incorrect in my spreadsheet? | Excel Worksheet Functions | |||
| help with spreadsheet calculations | Excel Worksheet Functions | |||
| How Can I "sign" a spreadsheet to verify I reviewed? | Excel Discussion (Misc queries) | |||
Linear Mode
