Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
1000+$K$5/1000 -what does $ indicate in formula
Whats the significance of $ symbol in the above formula. What action it
performs. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
1000+$K$5/1000 -what does $ indicate in formula
It makes K5 and absolute reference, so the formula always looks at that
cell, have a look at Switch between relative, absolute, and mixed references in help for more information -- Paul B Always backup your data before trying something new Please post any response to the newsgroups so others can benefit from it Feedback on answers is always appreciated! Using Excel 2002 & 2003 "Coolbhims" wrote in message ... Whats the significance of $ symbol in the above formula. What action it performs. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Formula Convert Digits to Words (1000 write One thousand) | Excel Worksheet Functions | |||
adding row to forumla | Excel Discussion (Misc queries) | |||
Creating a check mark box | Setting up and Configuration of Excel | |||
Match / Vlookup within an Array formula | Excel Discussion (Misc queries) | |||
Function Help | Excel Worksheet Functions |