| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
cell reference question
how do i write a function that basically says "if there's anything in cell
xx, return the data from that cell. if there is nothing in cell xx, leave the cell blank". |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
cell reference question
try
=IF(A1<"",A1,"") Mike "bfont" wrote: how do i write a function that basically says "if there's anything in cell xx, return the data from that cell. if there is nothing in cell xx, leave the cell blank". |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
cell reference question
Hi,
You can use =IF(A1="","",A1) or if the only things in A1 are numbers or formulas that return numbers: =IF(A1,A1,"") -- If this helps, please click the Yes button Cheers, Shane Devenshire "bfont" wrote: how do i write a function that basically says "if there's anything in cell xx, return the data from that cell. if there is nothing in cell xx, leave the cell blank". |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Cell reference question | Excel Worksheet Functions | |||
| Cell Reference Question | Excel Discussion (Misc queries) | |||
| cell reference question | New Users to Excel | |||
| Cell Reference Question | Excel Discussion (Misc queries) | |||
| Cell Reference Question | Excel Worksheet Functions | |||
Linear Mode
