help with Excel function

  • Thread starter Thread starter jayeliz
  • Start date Start date
J

jayeliz

hiyall

I need help with a function that will analyze a column of five cell
and if all five cells have data then it will place an "X" in
different cell.
Can this be done? I'd appreciate any help. Thanks
 
Hi j!

In the cell you want the x in use:

=IF(COUNTA(A1:A5)=5,"x","")

--
Regards
Norman Harker MVP (Excel)
Sydney, Australia
(e-mail address removed)
Excel and Word Function Lists (Classifications, Syntax and Arguments)
available free to good homes.
 
Thanks, Norman; I misread the question.

Regards,

Vasant.

Norman Harker said:
Hi j!

In the cell you want the x in use:

=IF(COUNTA(A1:A5)=5,"x","")

--
Regards
Norman Harker MVP (Excel)
Sydney, Australia
(e-mail address removed)
Excel and Word Function Lists (Classifications, Syntax and Arguments)
available free to good homes.
Click to expand...
 
Hi Jayeliz,

you can also try :-

=if(countblank(A1:A5)>0,"","x")

Regards,
Gilbert

P/S : To Norman, how about if the cells are of different rows an
columns...that is to say...say to check cell A1, B2, C1, D2, E1
 
Back
Top