Can anyone help me with an index and match excel formula problem. Any help would be very much appreciated.?

I need help with question 5. The only thing I would like help with is how to index and match within 1% of the grading scale. I understand that the match function provides 1,0,-1 to put at the end for match type but how could you make the percentage round up to the next highest grade only if it is within 1% away from the higher grade? I can figure the rest out on my own. I've been stuck on this for hours T.T

Update:

The numbers that are already on column N are what the formula should display after the formula is done correctly apparently.

Attachment image

1 Answer

Relevance
  • Clive
    Lv 7
    3 weeks ago

    What does this have to do with personal finance?

Still have questions? Get your answers by asking now.