cell reference question

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

Shane Devenshire

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

passing cell address to sub - write that cell 2
Vlookup i think >.< 6
Offset, sum down to the first blank row 7
Word macro that can call cells out of Excel for a find and replace 0
Index Match & #values 0
Excel 2013: How to ensure a cell is not left blank by users? (Not using VBA) 0
Converting a number into a cell reference 2
Drop-down calendar for sheet 0

Top