All is good with the adjusted grading now - and again THANK YOU SO MUCH for that. I have one more question. How do you go about changing the actual percentage score in B24 in the Audit Summary. I dont want to go changing the weighting in the main audit sheet, however was thinking of putting in another IF function. I tried a few variables such as +IF(D18=1,'58'), IF(D18=2,'47' etc but that didn't work (I also varied with ""). Then tried conditional formatting, but again that didn't work. I would like the score in B24 amended as follows:

Number of critical items in Audit Summary sheet D18 =
1 then score is 58 for B24 in Audit Summary sheet
2 then score is 47 for B24 in Audit Summary sheet
3 then score is 40 for B24 in Audit Summary sheet
4 then score is 33 for B24 in Audit Summary sheet
5 then score is 31 for B24 in Audit Summary sheet
6 then score is 27 for B24 in Audit Summary sheet
7 then score is 23 for B24 in Audit Summary sheet
8 then score is 19 for B24 in Audit Summary sheet
9 then score is 15 for B24 in Audit Summary sheet
10 then score is 11 for B24 in Audit Summary sheet
11 then score is 7 for B24 in Audit Summary sheet

I promise this is the last thing I need .....