ExcelBanter - cell reference question

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - cell reference question (https://www.excelbanter.com/excel-worksheet-functions/222186-cell-reference-question.html)

bfont

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

Mike H

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

Shane Devenshire[_2_]

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

All times are GMT +1. The time now is 06:47 PM.