Forum Discussion
If statement with AND & Blank
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.
