If statement with AND & Blank

New Contributor

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 Replies

@wmb8084 Use this one:

=IF(OR(ISBLANK(B2),ISBLANK(C2)),"NA",IF((AND(B2<=140, C2<=90,B2<>"",C2<>"",A2<80)), "True", "False"))
It works, thank you so much, sir.