ExcelBanter - IF and AND

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - IF and AND (https://www.excelbanter.com/excel-discussion-misc-queries/240997-if.html)

EwanRobson

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

All times are GMT +1. The time now is 12:21 AM.