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