Dear All
Its been a while since I was last on the website.
I am having an issue with returning a value from an index/match, the spreadsheet is working out scores for school grades - score(out of 50) then a %, and what the grade would be. When i get to the % values of 55,56,57,58 the formula is returning an error #NA and error. All other scores and grades are work & no issues with 54 or 59!! - would anyone know what is causing this.
Attached is a small extract from the spreadsheet to show an example.
Thanking you in advance.
Simon
Its been a while since I was last on the website.
I am having an issue with returning a value from an index/match, the spreadsheet is working out scores for school grades - score(out of 50) then a %, and what the grade would be. When i get to the % values of 55,56,57,58 the formula is returning an error #NA and error. All other scores and grades are work & no issues with 54 or 59!! - would anyone know what is causing this.
Attached is a small extract from the spreadsheet to show an example.
Thanking you in advance.
Simon