• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

INDEX/MATCH returning error on certain values

holmes18

New Member
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
 

Attachments

  • Chandoo_Forum.xlsx
    12 KB · Views: 3
Hi ,

The problem is floating point errors.

Change your calculation in cell E3 to :

=D3 * 100 / 50

instead of :

=D3 / 50 * 100

Narayan
Narayan - thank you very much and I think I had formula blindness after trying to think of what it might be, without considering this.
Regards and thanks
Simon
 
Back
Top