If statement with AND & Blank

[wmb8084]

Hello

I have three Conditions

• Age 80 or less
• Systolic 140 or less
• Diastolic 90 or less

I have attached my statement. It works but I want to add condition if the Systolic BP or Diastolic BP is (has no value) blank then return "NA"

[#2]

@wmb8084 Use this one:

=IF(OR(ISBLANK(B2),ISBLANK(C2)),"NA",IF((AND(B2<=140, C2<=90,B2<>"",C2<>"",A2<80)), "True", "False"))

[#3]

It works, thank you so much, sir.