cell reference question

  • Thread starter Thread starter bfont
  • Start date Start date
B

bfont

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

You can use

=IF(A1="","",A1)

or if the only things in A1 are numbers or formulas that return numbers:

=IF(A1,A1,"")
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Vlookup i think >.< 6
Offset, sum down to the first blank row 6
How to use number in some cell as a part of other cells reference? 4
First Day of the month 3
Countif or Sumproduct 2
Conditional Formatting HELP 2
IF Statements using BUT - is there such a thing 1
passing cell address to sub - write that cell 2

Back
Top