Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 2,069
Default 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   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 46
Default 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

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
how do you write format results of a function within a function? sangee Excel Worksheet Functions 3 June 14th 07 12:45 AM
Help me write a function please? justo316 Excel Worksheet Functions 10 January 12th 06 07:10 PM
help me write function? Zach Excel Worksheet Functions 5 August 3rd 05 03:12 PM
is there a way to write this function? Steve Excel Worksheet Functions 6 March 16th 05 03:48 PM
how do I write a vlookup function within an iserror function so t. JBLeeds Excel Worksheet Functions 2 March 16th 05 11:30 AM


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

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"