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 ...
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.
