| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How to to put together this function below
How put together this formula to determine if my blood pressure is in normal
range: If =<120 return "Normal" If between 121 and 139 return "Pre-hypertension" If between 140 and 159 return "Stage One" If greater than or equal to 160 "Stage Two" Thanks in advance. -- Pat Miller |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
How to to put together this function below
One way:
=LOOKUP(A1,{0,"Normal";121,"Pre-hypertension"; 140,"Stage One"; 160, "Stage 2"}) In article , Pat Miller wrote: How put together this formula to determine if my blood pressure is in normal range: If =<120 return "Normal" If between 121 and 139 return "Pre-hypertension" If between 140 and 159 return "Stage One" If greater than or equal to 160 "Stage Two" Thanks in advance. |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
How to to put together this function below
=IF(A1<121,"Normal",IF(A1<140,"Pre-hypertension",IF(A1<160,"Stage One","Stage
Two"))) "Pat Miller" wrote: How put together this formula to determine if my blood pressure is in normal range: If =<120 return "Normal" If between 121 and 139 return "Pre-hypertension" If between 140 and 159 return "Stage One" If greater than or equal to 160 "Stage Two" Thanks in advance. -- Pat Miller |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| LINKEDRANGE function - a complement to the PULL function (for getting values from a closed workbook) | Excel Worksheet Functions | |||
| Offset function with nested match function not finding host ss. | Excel Worksheet Functions | |||
| Emulate Index/Match combo function w/ VBA custom function | Excel Worksheet Functions | |||
| I want to use Vlookup function and AND function in a single formu. | Excel Worksheet Functions | |||
| Nested IF Function, Date Comparing, and NetworkDays Function | Excel Worksheet Functions | |||
Linear Mode
