| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
referencing a cell on another sheet
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. |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
referencing a cell on another sheet
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. |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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. |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
referencing a cell on another sheet
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. |
|
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
referencing a cell on another sheet
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. |
|
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
referencing a cell on another sheet
Gord, IMHO your function is needless, unless you can explain the difference with a simple reference =sheet1!k3 -- keepITcool | www.XLsupport.com | keepITcool chello nl | amsterdam Gord Dibben wrote : 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. |
|
#7
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
referencing a cell on another sheet
Hi keepITcool
Tried your function =sheet1!k3 and it places a zero in the cell. Whereas Glenn's & Gord leaves the cell blank which was what the op asked for. Do you configure Excel to not show a single zero's values in a cell? regards Bob C. "keepITcool" wrote: Gord, IMHO your function is needless, unless you can explain the difference with a simple reference =sheet1!k3 -- keepITcool | www.XLsupport.com | keepITcool chello nl | amsterdam Gord Dibben wrote : 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. |
|
#8
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
referencing a cell on another sheet
ouch.. oops... now how do i cancel that post.. <g -- keepITcool Robert Christie wrote : Hi keepITcool Tried your function =sheet1!k3 and it places a zero in the cell. Whereas Glenn's & Gord leaves the cell blank which was what the op asked for. Do you configure Excel to not show a single zero's values in a cell? regards Bob C. "keepITcool" wrote: Gord, IMHO your function is needless, unless you can explain the difference with a simple reference =sheet1!k3 -- keepITcool www.XLsupport.com | keepITcool chello nl | amsterdam Gord Dibben wrote : 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. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Sheet referencing in a cell | Excel Discussion (Misc queries) | |||
| Referencing every 5th cell in another sheet | Excel Worksheet Functions | |||
| referencing Excel sheet name in cell | Excel Worksheet Functions | |||
| referencing a sheet named in a cell then using data from that sheet | Excel Worksheet Functions | |||
| Referencing a cell containing sheet name | Excel Programming | |||
![JT[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Linear Mode
