How would I write a function to tell me whether a number was 'high' ,
'medium' or 'low' according to my specifications of what a high, medium
or low figure was ( for example, exam marks where a low is below 40,
medium between 41 and 70 and high above 70)


------------------------------------------------
~~ Message posted from http://www.ExcelTip.com/
~~View and post usenet messages directly from http://www.ExcelForum.com/

In the cell, try this (assume B1 is where the score is):

=If(B1<=40,"Low",If(B170,"High","Medium"))

-----Original Message-----

How would I write a function to tell me whether a number
was 'high' ,
'medium' or 'low' according to my specifications of what
a high, medium
or low figure was ( for example, exam marks where a low
is below 40,
medium between 41 and 70 and high above 70)


------------------------------------------------
~~ Message posted from http://www.ExcelTip.com/
~~View and post usenet messages directly from
http://www.ExcelForum.com/

.

danke schon- but could i do it as a program not an if statement? Even i
its a long way to do it, I wanna impress said examiner ;)

Thanks loads though *:D

-----------------------------------------------
~~ Message posted from http://www.ExcelTip.com
~~View and post usenet messages directly from http://www.ExcelForum.com

Alpha, here is one way =IF(A170,"High",IF(A140,"Medium","Low"))

--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 2000 & 97
** remove news from my email address to reply by email **
"AlphaElyssia" wrote in message
...

How would I write a function to tell me whether a number was 'high' ,
'medium' or 'low' according to my specifications of what a high, medium
or low figure was ( for example, exam marks where a low is below 40,
medium between 41 and 70 and high above 70)


------------------------------------------------
~~ Message posted from http://www.ExcelTip.com/
~~View and post usenet messages directly from http://www.ExcelForum.com/

Try this:

Function HighLow(ByRef InputCell As Range)
If Not WorksheetFunction.IsNumber(InputCell.Value) Then
HighLow = "Not Numeric"
Exit Function
End If
Select Case InputCell.Value
Case Is < 41: HighLow = "Low"
Case 41 To 70: HighLow = "Medium"
Case Is 70: HighLow = "High"
Case Else
End Select
End Function

Regards

Trevor


"AlphaElyssia" wrote in message
...

danke schon- but could i do it as a program not an if statement? Even if
its a long way to do it, I wanna impress said examiner ;)

Thanks loads though *:D*


------------------------------------------------
~~ Message posted from http://www.ExcelTip.com/
~~View and post usenet messages directly from http://www.ExcelForum.com/