Forum Discussion
Andrea Rusco Heller
Oct 21, 2017Copper Contributor
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
- SergeiBaklanDiamond 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.