Can I use the IF function to display a message

[oilhen]

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.

 

[Pete_UK]

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

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

Hope this helps.

Pete

 

[nader]

hi oilhen

I wrote this function and examed it.
"A1" cell,for functhon(message) and "A2" cell,for number.

 

[David Biddulph]

Interesting that you've decided to exclude values between 29.9 and 30 (and
would therefore return FALSE for an input within that range), but you've
given an answer for those between 24.9 and 25. The OP, of course, should
have been clearer.

 

[oilhen]

Dear All,

It's work fine, thanks all

Oilhen

Interesting that you've decided to exclude values between 29.9 and 30 (and
would therefore return FALSE for an input within that range), but you've
given an answer for those between 24.9 and 25. The OP, of course, should
have been clearer.