Oct 05 2021 04:54 AM
Hello
I have three Conditions
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"
Oct 05 2021 04:59 AM
@wmb8084 Use this one:
=IF(OR(ISBLANK(B2),ISBLANK(C2)),"NA",IF((AND(B2<=140, C2<=90,B2<>"",C2<>"",A2<80)), "True", "False"))