number range returning a text value
Jason
Try: =IF(A1<6,"Low",IF(A19,"High","Medium"))
George Gee
"jason" wrote in message
...
Hi,
I would like to be able to return a specific text when a number is added
to
a column. For example, if a number is inputted and it falls within the
range
"1-5", then the text field "low" is returned. If however "6" is inputted,
the
result would give the text "Medium", and if "10" is inputted, the
returning
text field is "High"
Thanks for any help
|