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,584
    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

Some videos you may like

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
  •