New Contributor

I would like to have a formula that would put the amount of "580" in another column after I input an "X" in another column:  If(+F114=X)(+E114=580). I would be entering data in column form, column 'F' in blank, but when I enter the "X" then the system inputs the amount "580" into column 'E'. 

4 Replies


An Excel formula or function returns a value only in the cell where it it entered.

So, in cell E114 you could enter =if(F114="X",580,"").

No, it has to be in a differance column.


As @MichaelRoryMiddleton mentioned, you cannot do that with a formula. A formula can only return a value in its own cell, not in another cell.


I think you asked for this. See attached