Thread: IF and AND
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
EwanRobson EwanRobson is offline
external usenet poster
 
Posts: 1
Default IF and AND

please can anyone help with this. I have 8 cells that are grouped 5, 2 & 1.

I wish was to display if all 5 cells are filled make Level 1, 5 cells plus
the following are filled then say Level 2 and if all cells are filled say
Level 3.

Thanks in anticipation