I need to create a formula like the following-
=IF(I6>=80,"A+", IF(I6>=75,"A", IF(I6>=70,"A-", IF(I6>=65,"B+", IF(I6>=60,"B", IF(I6>=55,"B-", IF(I6>=50,"C+", IF(I6>=45,"C", IF(I6>=40,"D","F")))))))))
But Excel is not taking function more then 7. Now how can I make it possible?
you can have the file on this link to download.
** I am using Microsoft Excel 2003
Hi,
Try: =LOOKUP(I6,{0,40,45,50,55,60,65,70,75,80},{"F","D","C","C+","B-","B","B+","A-","A","A+"})
Dom
"May the fleas of a thousand camels infest the crotch of the person who screws up your day and may their arms be too short to scratch..."
Use code tags when posting your VBA code: [code] Your code here [/code]
Remember, saying thanks only takes a second or two. Click the little star to give some Rep if you think an answer deserves it.
Thank You very much. Its really workingOriginally Posted by Domski
Thanks again.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Reply With Quote
Bookmarks