| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Constant in Excel Formula
That is exactly what it does - keeps the row or column constant depending
upon where it is inserted. If before the column, then the column is constant. Please read up on absolute and relative references in Help menu -- Regards, Ashish Mathur Microsoft Excel MVP www.ashishmathur.com "Chele" wrote in message ... I remember using the $ i think to keep a column constant when doing a formula. What is it? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I add a formula to a cell containing a constant value | Excel Discussion (Misc queries) | |||
| Set a constant from a formula in VBA | Excel Discussion (Misc queries) | |||
| Excel displaying formulae as constant and not calculating formula | Excel Worksheet Functions | |||
| Formula Constant | Excel Worksheet Functions | |||
| Constant Value in formula. | Excel Worksheet Functions | |||
![Ashish Mathur[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Hybrid Mode
