Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Coolbhims
 
Posts: n/a
Default 1000+$K$5/1000 -what does $ indicate in formula

Whats the significance of $ symbol in the above formula. What action it
performs.
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Paul B
 
Posts: n/a
Default 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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Formula Convert Digits to Words (1000 write One thousand) Excel Excel Worksheet Functions 3 November 27th 05 01:02 PM
adding row to forumla carrera Excel Discussion (Misc queries) 9 August 23rd 05 10:24 PM
Creating a check mark box MarthaSue Setting up and Configuration of Excel 18 April 28th 05 12:31 AM
Match / Vlookup within an Array formula Hari Prasadh Excel Discussion (Misc queries) 3 February 3rd 05 05:37 PM
Function Help Steven M. Britton Excel Worksheet Functions 0 December 9th 04 04:33 PM


All times are GMT +1. The time now is 10:25 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"