Insert the following formula in cell F1 on Sheet 2:

=if('Sheet 1'K3="","",'Sheet1'K3)

-Glenn Ray


"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.