Excel IF & AND formula if blank-CodePudding

I have this formula and its working great, but when all columns blank the formula shows "Requires Improvement" . I need if all columns blank the result here it should be blank

=IF(AND(AD15>AD16,AD15>AD17),"Effective",IF(AND(AD16>=AD15,AD16>=AD17),"Requires Improvement",IF(AND(AD17>AD15,AD17>AD16),"Requires Immediate Attention")))

CodePudding user response：

If your current formula works fine then just replace Requires Improvement with empty string. Try-

=IF(AND(AD15>AD16,AD15>AD17),"Effective",IF(AND(AD16>=AD15,AD16>=AD17),"",IF(AND(AD17>AD15,AD17>AD16),"Requires Immediate Attention")))

CodePudding user response：

Using IFS() and handling unanticipated situations:

=IFS(AND(AD15="",AD16="",AD17=""),"",AND(AD15>AD16,AD15>AD17),"Effective",AND(AD16>=AD15,AD16>=AD17),"Requires Improvement",AND(AD17>AD15,AD17>AD16),"Requires Immediate Attention",TRUE,"Other Situation")