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
The numbers that are already on column N are what the formula should display after the formula is done correctly apparently.
- CliveLv 73 weeks ago
What does this have to do with personal finance?