1000+$K$5/1000 -what does $ indicate in formula
Whats the significance of $ symbol in the above formula. What action it
performs. |
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. |
All times are GMT +1. The time now is 10:09 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com