Hi everyone can someone please help me with what I believe is a minor problem (at least I hope it is!!) I have a spreadsheet that calculates verious total values. What I want to achieve is if these values are between 2.5 and 4.4 to append "PASS" , if the value is between 4.5 and 6.4 to append "MERIT" and if the value is 6.5 and over "DISTINCTION in the adjacent cell. Any help would be greally appreciated.
Thanks in anticipation
Integrity
Try this
=IF(AND(A2>=2.5,A2<=4.4),"PASS",IF(AND(A2>=4.5,A2<=6.4),"MERIT",IF(A2>=6.5,"DISTINCTION","NA")))
I have put NA for values less than 2.5. You can change that to whatever you want.
If I have helped, Don't forget to add to my reputation (click on the star below the post)
Don't forget to mark threads as "Solved" (Thread Tools->Mark thread as Solved)
Use code tags when posting your VBA code: [code] Your code here [/code]
=LOOKUP(A1, {0,2.5,4.5,6.5}, {"Fail","Pass","Merit","Distinction"})
@Arlu: What does your formula return for 4.45?
Entia non sunt multiplicanda sine necessitate
Hmmm NA, why is that so?
Try the Evaluate Formula button.
Thank you so much guys for your rapid response to my problem. I am pleaseed to report tat the issue has been solved sucessfully. Indeed you are a credit to the forum.
Best regards
Integrity
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks