View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.programming
TroyW[_2_] TroyW[_2_] is offline
external usenet poster
 
Posts: 94
Default referencing a cell on another sheet

Here is one approach:

F1: =IF(LEN(Sheet1!K3)0,Sheet1!K3,"")

Troy

"JT" wrote in message
...
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.