+ Reply to Thread
Results 1 to 2 of 2

'$'

  1. #1
    Kamran
    Guest

    '$'

    Please define in some of the excel formulas and function we '$' (Doller sign)
    what is its function in cell ranges and why it is written like this in few of
    the formulas; =IF($A$1=100,.....), and what we call this function.... plz
    reply...

    With kind regards,
    Kamran

  2. #2
    Bob Phillips
    Guest

    Re: '$'

    It locks that cell reference, so if it is copied to another cell, it will
    still refer to the same source.

    So in your example, if that formula is in B1, and you copy it to B2, it will
    still say =IF($A$1=100,...).

    If it were relative, =IF(A1=100,...), it would get updated to
    =IF(A2=100,...)

    --

    HTH

    RP
    (remove nothere from the email address if mailing direct)


    "Kamran" <Kamran@discussions.microsoft.com> wrote in message
    news:5ACBD413-3680-4C3C-8465-00B069BDA303@microsoft.com...
    > Please define in some of the excel formulas and function we '$' (Doller

    sign)
    > what is its function in cell ranges and why it is written like this in few

    of
    > the formulas; =IF($A$1=100,.....), and what we call this function.... plz
    > reply...
    >
    > With kind regards,
    > Kamran




+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1