View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
John
 
Posts: n/a
Default Setting up a condtional function that....

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