Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Function containing $
What is the rwason for using the $ sign. I used
"=IF(Sat!$H$22=0,"",Sat!$H$22)" but i get the same result using "=IF(Sat!H22=0,"",Sat!H22)". |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Function containing $
The $ symbol in front of the row (or column) identifier means that the
row (or column) will not change when the formula is copied down (or across) - it is thus considered to be "anchored" to the cell. Check out what happens to the cell references in your two formulae if you copy them across and down your sheet. Check out Excel Help on Absolute References for more. Hope this helps. Pete On Jan 23, 3:32*pm, Dave wrote: What is the rwason for using the $ sign. I used "=IF(Sat!$H$22=0,"",Sat!$H$22)" but i get the same result using "=IF(Sat!H22=0,"",Sat!H22)". |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Function containing $
Hi,
The $ sign fixes the reference such that if you drag the formula dow or across it doesn't change. if you drag the formula =a1 down it becomes =A2 but if you have =$A$1 and rag it it doesnt change There are 4 states of reference Relative =A1 Row absolute = A$1 Column absolute =$A1 Absolute =$A$1 Mike "Dave" wrote: What is the rwason for using the $ sign. I used "=IF(Sat!$H$22=0,"",Sat!$H$22)" but i get the same result using "=IF(Sat!H22=0,"",Sat!H22)". |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
ISBLANK function not working when cell is blank dut to function re | Excel Discussion (Misc queries) | |||
copy of excel file not showing formulal/function in the function b | Excel Discussion (Misc queries) | |||
LINKEDRANGE function - a complement to the PULL function (for getting values from a closed workbook) | Excel Worksheet Functions | |||
Offset function with nested match function not finding host ss. | Excel Worksheet Functions | |||
Emulate Index/Match combo function w/ VBA custom function | Excel Worksheet Functions |