IF help

sowetoddid · Nov 6, 2003

Is there a way to make an IF statement based on whether or not a cell
has something/anything in it?

If A1:A2000 have "something in them" then....

Jason Morin · Nov 6, 2003

=IF(COUNTBLANK(A1:A2000)<>2000,---,---)

HTH
Jason
Atlanta, GA