KAPOW

Would you like to react to this message? Create an account in a few clicks or log in to continue.
KAPOW

Welcome to the Kapow forum. Here you can get help, use your skills to help others and enjoy hanging out in the company of other Kapow Robot Developers.


2 posters

    writing excel formula

    avatar
    chrismemo


    Posts : 15
    Points : 2216
    Join date : 2018-04-24
    Location : Singapore

    writing excel formula Empty writing excel formula

    Post by chrismemo Thu Jan 24, 2019 5:40 pm

    Hi,

    How do we write excel formula with relative address and when looping for each row?

    For example: cell C =cell B* cell A, where:
    B is 1 cell to the left from C and A is 2 cells to the left from C.

    Thanks,
    Chris
    jking
    jking


    Posts : 103
    Points : 3851
    Join date : 2014-03-01
    Location : USA

    writing excel formula Empty Re: writing excel formula

    Post by jking Thu Jan 24, 2019 8:32 pm

    Add a new variable CellA (Number)
    Add a new variable CellB (Number)
    Add a new variable CellC (Number)
    Extract value of cell A into variable CellA
    Extract value of cell B into variable CellB
    Add an Assign Variable Step.  Value will be Expression.  Variable will be CellC.  Expression is CellA*CellB.
    Right-Click on Cell C.  Select Set Content of Cell.  Click drop-down box next to Content and Select Variable.  Select variable CellC.


    writing excel formula Calcul10

      Current date/time is Sat Apr 27, 2024 8:17 am