Using function on column?

  • Thread starter Thread starter KarenABS
  • Start date Start date
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
 
Hi,

I'm afraid the formula you are using as an example doesn't make sense
becuase it returns E8 for both tru and false. You could apply a logical test
to en entire column

=IF(COUNTA(C:C)=0,E8,F8)

But note iv'e made it returns different references for true (E8) and false
(F8)

Mike
 
It is supposed to be if text is in column C then I need column A to have the
same value as E. If it is not text then it should not copy...I must not have
had any non text.
 
Back
Top