Assuming your value is in A1, put this in B1:

=IF(A1<18.5,"Under",IF(A1<25,"Normal",IF(A1<30,"Ov er","Danger")))

Hope this helps.

Pete

On Jun 16, 11:09*am, "oilhen" wrote:
I want to display a message in a cell, but I'm not sure the "IF" function
can do this?

Example:

a.. Under = <18.5
a.. Normal = 18.5-24.9
a.. Over = 25-29.9
a.. Danger = *greater 30

Thanks.