Hi friends,
I want to create a formula in Excel 2007 that calculate grade based on percentage for that i have created some formula but was not able to get the exact solution. Example, if the change is <=-7.5%, score is 100. If the change is >=-7.5% and <=-5.0%, score is 98. And so on. Now I could just make a long Nested If to compare the change against my criteria and assign a score. But I hope that somebody here might know a more robust way of doing this.
Bookmarks