help with Excel function

[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

 

[Vasant Nanavati]

=IF(COUNTA(A1:A5)>0,"X","")

 

[Norman Harker]

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.

 

[Vasant Nanavati]

Thanks, Norman; I misread the question.

Regards,

Vasant.

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.

 

[jayeliz]

Norman, Vassant thank you much. Great site!

 

[gilbert]

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

 

[Frank Kabel]

Hi
try
=IF(COUNTA(A1,B2,C1,D2,E1)=5,"x","")