Automatically enter cell value based on the values of two other cells

I am working on blood pressures. I want cell C1 to place either, "Prehypertension","Stage I Hypertension" or, "Stage II Hypertension" depending on the values of cells A1 or B1

If (A1>=120 AND A1<=139) OR (B1>=80 AND B1<=89) then C1 should equal, "Prehypertension"

If (A1>=140 AND A1<=159) OR (B1>=90 AND B1<=99) then C1 should equal, "Stage I Hypertension"

If (A1>=160) OR (B1>=100) then C1 should equal, "Stage II Hypertension"

If the values do not meet any of this criteria, then C1 should equal, "NORMAL"

This is what I have written. I have edited it a number of times but have not yet been successfull in getting it right.

=IF((OR(AND(A2>=120,A2<=139,B2>=80,B2<=89)),"Prehypertension")(OR(AND(A2>=140,A2<=159,B2>=90,B2<=99)),"Stage I Hypertension")(OR(AND(A2>=160,B2>=100)),"Stage II Hypertension"),NORMAL)

I am using Excel 2007 and I have attached the book with the code.

Hi Check it out

Please Login or Register  to view this content.