Help Please!!

  • Thread starter Thread starter Oppie1
  • Start date Start date
O

Oppie1

Create a function in the Level column that will evaluate the regents
score and determine if the score falls into one of these categories

0%-54%
based upon the result of the function display - 0-54

55%-64%
based upon the result of the function display - 55-64

65%-84%
based upon the result of the function display - 64-84

85%-100%
based upon the result of the function display - 85-100

How the hell do i create a forumla to do that!??!?!?!




+----------------------------------------------------------------+
| Attachment filename: exam2img.jpg |
|Download attachment: http://www.excelforum.com/attachment.php?postid=371781|
+----------------------------------------------------------------+
 
What result are you talking about? You say "based upon the results
of the function..." but you do not say what function you are talking
about.

Your example does not cover what happens when the percentage is
less than 0%, greater than 100% or between 54% and 55%, say 54.5%.
You also have other inconsistencies. One group is 0-54 and the next
it 55-64. You leave out greater than 54 and less than 55 but in the next
category you say 65%-84% but want to label it "64-84".

To get Excel to give what you want you need to make sure you cover
all possibilities. Basically this will do it.

= IF( MyFunction() >=0, IF( MyFunction() <= 0.54, "0-54",IF( MyFunction()<=0.64,"55-64",IF( MyFunction()<=0.84,"64-84",IF(
MyFunction<=1,"85-100","More than 100%"),"Less than 0%")

Replace MyFunction with your function or a cell reference.

Steve.


Oppie1 wrote
 
Something like:

In cell D2:

=IF(C2<55,"0-54",IF(C2<65,"55-64",IF(C2<85,"65-84","85-100")))

Copy down.
 
Back
Top