Result in different cell

[Alan]

Hi,

I have the following formula in cell f2:

=IF(A2<>"",B2-C2,"")

i want the result of B2-C2 to be put into cell E2 whilst
keeping the formula in F2.. How do i do that?

Many Thanks

Alan

 

[Norman Harker]

Hi Alan!

A formula or function in one cell cannot put data into another cell.

But in E2 you can use =F2

--
Regards
Norman Harker MVP (Excel)
Sydney, Australia
(e-mail address removed)
Excel and Word Function Lists (Classifications, Syntax and Arguments)
available free to good homes.