I am struggling to compose the correct syntax for these IF's, AND's in one formula.
IF B11 >0,
AND result from, =SUMIFS(N5:N16,Q5:Q16,"") returns 0
Then return "h"
IF B11 =0
OR B11 =""
Then return "q"
Can anyone help. Thanks.
Dan
IF B11 >0,
AND result from, =SUMIFS(N5:N16,Q5:Q16,"") returns 0
Then return "h"
IF B11 =0
OR B11 =""
Then return "q"
Can anyone help. Thanks.
Dan