If statement with AND & Blank

%3CLINGO-SUB%20id%3D%22lingo-sub-2812654%22%20slang%3D%22en-US%22%3EIf%20statement%20with%20AND%20%26amp%3B%20Blank%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2812654%22%20slang%3D%22en-US%22%3E%3CP%3EHello%3C%2FP%3E%3CP%3EI%20have%20three%20Conditions%3C%2FP%3E%3CUL%3E%3CLI%3EAge%2080%20or%20less%3C%2FLI%3E%3CLI%3ESystolic%20140%20or%20less%3C%2FLI%3E%3CLI%3EDiastolic%2090%20or%20less%3C%2FLI%3E%3C%2FUL%3E%3CP%3EI%20have%20attached%20my%20statement.%20It%20works%20but%20I%20want%20to%20add%20condition%20if%20the%20%3CSTRONG%3ESystolic%20BP%3C%2FSTRONG%3E%20or%20%3CSTRONG%3EDiastolic%20BP%3C%2FSTRONG%3E%20is%20(has%20no%20value)%20blank%20then%20return%20%22NA%22%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2812654%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2812687%22%20slang%3D%22en-US%22%3ERe%3A%20If%20statement%20with%20AND%20%26amp%3B%20Blank%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2812687%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1175502%22%20target%3D%22_blank%22%3E%40wmb8084%3C%2FA%3E%26nbsp%3BUse%20this%20one%3A%3C%2FP%3E%3CPRE%20class%3D%22lia-code-sample%20language-excel-formula%22%3E%3CCODE%3E%3DIF(OR(ISBLANK(B2)%2CISBLANK(C2))%2C%22NA%22%2CIF((AND(B2%26lt%3B%3D140%2C%20C2%26lt%3B%3D90%2CB2%26lt%3B%26gt%3B%22%22%2CC2%26lt%3B%26gt%3B%22%22%2CA2%26lt%3B80))%2C%20%22True%22%2C%20%22False%22))%3C%2FCODE%3E%3C%2FPRE%3E%3C%2FLINGO-BODY%3E
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.