Remember Me?

#1
Posted to microsoft.public.excel.worksheet.functions
 external usenet poster Posts: 2,069
How do I write thia function?

I write a function for compiling students exam results:

Knowledge Scienctif Process Complex Reasoning
80% 80% 60%

Very High Achivement
65% 65% 40%

High Achivement
45% 45% 0%

Sound Achivement
25% 25%

Low Achivement
<25% <25%
Very low Achivement
#2
Posted to microsoft.public.excel.worksheet.functions
 external usenet poster Posts: 46
How do I write thia function?

Setup a table like this

0 Very Low Achievement
0.25 Low Achievement
0.45 Sound Achievent
0.65 High Achievement
0.8 Very High Achievement

I set this up in B6:C10

Then, after calculating a students % score use the vlookup function as follows
=VLOOKUP(C15,\$B\$6:\$C\$10,2,TRUE)

The C15 is where I placed the score to lookup. The absolute references
\$B\$6:\$C\$10 are to ensure that you can copy the formula to adjacent cells
properly. The true value is a range lookup, the 2 refers to the second column
of the table from which we display the results.

You might need to play a little with the numbers is column B of the table to
deal with a score that hits the % boundaries exactly

"John" wrote:

I write a function for compiling students exam results:

Knowledge Scienctif Process Complex Reasoning
80% 80% 60%

Very High Achivement
65% 65% 40%

High Achivement
45% 45% 0%

Sound Achivement
25% 25%

Low Achivement
<25% <25%
Very low Achivement

 Posting Rules Smilies are On [IMG] code is On HTML code is OffTrackbacks are On Pingbacks are On Refbacks are On

 Similar Threads Thread Thread Starter Forum Replies Last Post sangee Excel Worksheet Functions 3 June 14th 07 12:45 AM justo316 Excel Worksheet Functions 10 January 12th 06 07:10 PM Zach Excel Worksheet Functions 5 August 3rd 05 03:12 PM Steve Excel Worksheet Functions 6 March 16th 05 03:48 PM JBLeeds Excel Worksheet Functions 2 March 16th 05 11:30 AM

All times are GMT +1. The time now is 06:11 AM.