Jun 03 2022 02:29 PM
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'.
Jun 03 2022 02:48 PM
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,"").
Jun 04 2022 02:41 AM
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.
Jun 04 2022 07:03 AM
I think you asked for this. See attached