View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
JE McGimpsey JE McGimpsey is offline
external usenet poster
 
Posts: 4,624
Default 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.