Using function on column?

K

KarenABS

I am using this function =IF(ISBLANK($C8),($E8),($E8)) on individual cells
and it is working fine. My issue is when refreshing the data I won't know
how many cells will need the function. Can I use a similar function on an
entire column?
Thanks, Karen
 
S

Shane Devenshire

Your goal is unclear. Mike has pointed out one of the problems, but in
addition what do you mean by "can I use a similar function on the whole
column" As stated the answer is just copy the formula all the way down the
column.

You should probably revise the formula to read

=IF(ISBLANK($C8),$E8,"")

or

=IF(C8="",E8,"")
 
K

KarenABS

Boy I just keep finding out what I don't know!!!
Could you help me to say if it is not blank then do the copy?
 

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

How can I use an if formula that works on a cell with column? 4
Excel - Wich Function should I use? 1
Basing math on duplicate entries in a formula 1
Cell Referencing 5
Time Sum in Excel 1
A Percentile IF function 1
Standard Deviation and Averages based on criteria 2
Using ISNA function, but replace the blank cell with text 3

Top