Forum Discussion
Formula
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'.
I think you asked for this. See attached
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.
