Results 1 to 3 of 3

Thread: [RESOLVED] Calculating a cell value in function of another cell value

  1. #1

    Thread Starter
    Member
    Join Date
    Feb 2008
    Location
    LISBON
    Posts
    34

    Resolved [RESOLVED] Calculating a cell value in function of another cell value

    Hello, people i´m not geting a way to do this...

    I Have an entire column(A) to test(If) and another column(b) to fill with values in function of value from column(A)

    for example

    if cells("A1").value = x or > x then cells("A2").value = cells("A1").value + 1

    got the idea?

    many thankx

  2. #2
    Discovering Life Siddharth Rout's Avatar
    Join Date
    Feb 2005
    Location
    Mumbai, India
    Posts
    12,001

    Re: Calculating a cell value in function of another cell value

    I have posted in your other thread on how to "address" cells. once you get that we will go forward with what you are trying to achieve...
    A good exercise for the Heart is to bend down and help another up...
    Please Mark your Thread "Resolved", if the query is solved


    MyGear:
    ★ CPU ★ Ryzen 5 5800X
    ★ GPU ★ NVIDIA GeForce RTX 3080 TI Founder Edition
    ★ RAM ★ G. Skill Trident Z RGB 32GB 3600MHz
    ★ MB ★ ASUS TUF GAMING X570 (WI-FI) ATX Gaming
    ★ Storage ★ SSD SB-ROCKET-1TB + SEAGATE 2TB Barracuda IHD
    ★ Cooling ★ NOCTUA NH-D15 CHROMAX BLACK 140mm + 10 of Noctua NF-F12 PWM
    ★ PSU ★ ANTEC HCG-1000-EXTREME 1000 Watt 80 Plus Gold Fully Modular PSU
    ★ Case ★ LIAN LI PC-O11 DYNAMIC XL ROG (BLACK) (G99.O11DXL-X)
    ★ Monitor ★ LG Ultragear 27" 240Hz Gaming Monitor
    ★ Keyboard ★ TVS Electronics Gold Keyboard
    ★ Mouse ★ Logitech G502 Hero

  3. #3

    Thread Starter
    Member
    Join Date
    Feb 2008
    Location
    LISBON
    Posts
    34

    Re: Calculating a cell value in function of another cell value

    ok it´s resolved thankx koolsid

Posting Permissions

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



Click Here to Expand Forum to Full Width