Forum Discussion

Andrea Rusco Heller's avatar
Andrea Rusco Heller
Copper Contributor
Oct 21, 2017

Excel if an function

I am trying to write an IF(AND) function to say that if column A2>0 and column D2 contains text, then D2 equals A2. This function will of course contain more rows, therefore the columns will change as well as the rows.

1 Reply

  • SergeiBaklan's avatar
    SergeiBaklan
    Diamond Contributor

    Hi Andrea,

     

    You can't take the value of the cell (D2) into the formula and return the result into the same cell. If only into another cell.