Collage Grading

OGKnotty

New Member
Joined
Nov 27, 2017
Messages
1
hello,

I have tried to do this my self but this is abit bigger than my skill set, im trying to make my grading spreedsheet easier for me to read, I have want to have it so that when ever I pass the pass work I want it to come up with pass and then when I pass merit, I want it to say merit, so on, would you be able to advise on this anyone.
 

Excel Facts

Ambidextrous Undo
Undo last command with Ctrl+Z or Alt+Backspace. If you use the Undo icon in the QAT, open the drop-down arrow to undo up to 100 steps.
.
Your request is confusing. You can see what you want but we cannot. You will need to be more specific
with your description ... perhaps providing an example of what you have and what the outcome should be.

You can post a sample workbook on DropBox.com or Amazon Cloud or similar, with a link here.

Thanks.
 
Upvote 0
Agree with Logit that we need more details.

However, if you are basing this on a certain numeric value, then maybe something like this...
=if(value>=merit-value, "Merit" ,if(value>=pass-value, "Pass","")
you could add extra levels to this, if needed, just start with the largest and work down to the smallest
 
Upvote 0

Forum statistics

Threads
1,213,497
Messages
6,114,002
Members
448,543
Latest member
MartinLarkin

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top