Probably a stupid question..but Im just starting out

A

AlphaElyssia

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)
 
A

AlphaElyssia

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
 
T

Trevor Shuttleworth

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
 
Top