JT

In F1 of Sheet2

=IF(Sheet1!K3="","",Sheet1!K3)


Gord Dibben Excel MVP

On Tue, 5 Apr 2005 14:57:34 -0700, "JT"
wrote:

I want "F1" (on sheet 2) to display what is on sheet
1 "K3".

If "K3" (sheet 1) is empty, I want "F1" (sheet 2) to be
blank.

I should be able to write a formula but I'm having trouble
with the syntax.

Any help would be greatly appreciated. Thanks.