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/

.