View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Archana Archana is offline
external usenet poster
 
Posts: 5
Default Long Logical function

I have a tracking sheet where I want to enter a formula to enter in cell
"done" if a range of cells from A3:A54 all have a value "done" or "NA" else
keep blank.
How do I do it?
The formula is turning out t be too long and cannot be entered.