Thanks, that was very helpful. I removed the quotes around the true result
and removed the quotes in the false result and it updates the function
perfectly. I ended up with this:

=IF(D2="text", G2,"")

Craig

"David Biddulph" wrote:

You haven't given a reference cell of the true result, you have given a text
string "G2".
If you wish G2 to be a cell reference, it doesn't have quotes around it. In
that case it will happily update as you copy to the row below.
Similarly, if you want the alternative result to be number zero, rather than
a text string, you don't want the quotes round that either.
--
David Biddulph

Craig wrote:
Hi,

I need help with this function.

=IF(D2="text", "G2","0")

When I copy the formula to the cells below it changes the reference
of the logical test, which is great, but I also need it to change the
reference cell of the true result. So that when I copy it to the
cell below it becomes:

=IF(D3="text", "G3","0")

Thanks,

Craig