Modifying the contents of a cell using the cell itself
Eliminate Pivot Table Annoyances
Thanks Thanks:  0
Likes Likes:  0
Results 1 to 2 of 2

Thread: Modifying the contents of a cell using the cell itself

  1. #1
    Guest

    Default

     
    Hello, Is it possible to change the contents of a numeric cell by adding a 1 for example using the contents of the cell itself like:
    C1=15 and D1=1
    If D1=1 then C1=C1+1
    Hope I was clear. Thanks you anyway.
    Anarna

  2. #2
    Board Regular
    Join Date
    Feb 2002
    Location
    Perth Australia
    Posts
    1,579
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

      
    Hi
    I don't think you can do this by formula but you can do it by vb code:

    If Range("D1").Value = 1 Then Range("C1").Value = Range("C1").Value + 1

    (code is all on one line)
    hope this helps
    regards
    Derek

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

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

 

 
DMCA.com