Genius! Thanks Mike.

PS. Is there anyway that the copied contents of Cell R5 (ie. once they are
in cell A37) can be preceded by a couple of words of text, which will always
be the same? Thanks again.

"Mike H" wrote:

Sue,

This goes in A37

=IF(B37<"",R5,"")

Mike

"Sue C" wrote:

I think IF is the correct formula to use here, but can't get it to work.

I have a cell in which I want to copy the value (which will be a number)
from another cell, but only if a third cell has an entry in it (which will be
text). How do I use the IF syntax to say IF B37 has any value in it, then
copy R5 into A37? Thanks. Sue