Not sure, maybe you mean something like,
In C1: =IF(COUNTA(A:A)=0,"",B1)
and with C1 copied down
--
Rgds
Max
xl 97
---
Singapore, GMT+8
xdemechanik
http://savefile.com/projects/236895
--
"John" wrote in message
...
I'm looking to set up a conditional function for two entire columns.
Rather
than saying if A1="blank" I want to say if any of the cells in column
A="blank" than the corresponding C cell in that row will be "blank." So
that
the c column in the entire spreadsheet is designed around that one formula
contingent upon any cell in the A column. Help would be greatly
appreciated.
thank you