Glenn
now that makes sense.. but can you explain the difference?

=sheet1!k3

=if(sheet1!k3="";"";sheet1!k3)





--
keepITcool
| www.XLsupport.com | keepITcool chello nl | amsterdam


Glenn Ray wrote :

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.