Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Can I use the IF function to display a message
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. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Can I use the IF function to display a message
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. |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Can I use the IF function to display a message
hi oilhen I wrote this function and examed it. "A1" cell,for functhon(message) and "A2" cell,for number. =IF(A2<=18.5,"under",IF(A2<=24.9,"normal",IF(A2<=2 9.9,"over",IF(A2=30,"danger")))) pleas send me e-mail a bout this subject and others. thanks. "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. |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Can I use the IF function to display a message
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. -- David Biddulph "nader" wrote in message ... hi oilhen I wrote this function and examed it. "A1" cell,for functhon(message) and "A2" cell,for number. =IF(A2<=18.5,"under",IF(A2<=24.9,"normal",IF(A2<=2 9.9,"over",IF(A2=30,"danger")))) pleas send me e-mail a bout this subject and others. thanks. "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. |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Can I use the IF function to display a message
Dear All,
It's work fine, thanks all Oilhen "David Biddulph" <groups [at] biddulph.org.uk ... 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. -- David Biddulph "nader" wrote in message ... hi oilhen I wrote this function and examed it. "A1" cell,for functhon(message) and "A2" cell,for number. =IF(A2<=18.5,"under",IF(A2<=24.9,"normal",IF(A2<=2 9.9,"over",IF(A2=30,"danger")))) pleas send me e-mail a bout this subject and others. thanks. "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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Display a message | Excel Worksheet Functions | |||
Display a message | Excel Worksheet Functions | |||
how to display an error message | Excel Worksheet Functions | |||
How do I display a message when a cell has a certain value?? | Excel Discussion (Misc queries) | |||
Display a message when a file is opened. | New Users to Excel |