=IF(F1<0,F1,G1)

If F1 is less than or greater than 0, F1, else G1.

Dave
--
Brevity is the soul of wit.


"katie" wrote:

I have two columns of figures i.e. Col. G has figures in each cell and have
totalled them and averaged them. In Col. F most of the cells have 0, but if
a cell is populated with a figure other than 0, then I need to use that
figure instead of the figure in Row G.