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 a...
Formulas & Functions
Need Help
SergeiBaklan's avatar
SergeiBaklan
Diamond Contributor
Oct 21, 2017

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.