Hi Everyone - I want to write an IFS formula to display YES if the sum of 3 separated cells (they are not in a continuous range) equals zero; displays NO if the sum of the same 3 cells is <> zero; and does not calculate at all when all three separated cells are blank.

I can write the IFS formula just fine for the first two conditions: =IFS(A1+B5+C10=0,"YES",A1+B5+C10<>0,"NO")



...but I can't seem to figure out how to write the formulate so it will not calculate at all when all three cells are blank.

Can anyone help me figure this out?