Jun 12 2019 02:49 AM
Hi,
I am using the formula =IF(OR(C3=0, H3=0, M3=0, R3=0, W3=0, AB3=0), "Yes", "No") to test for zeroes.
If one of the cells is blank I do not want to count this as a zero, but rather have it ignored.
Any help much appreciated,
Thanks
Jun 12 2019 07:34 AM
@Carl_Orlowe
It could be
=IF(SUMPRODUCT((INDEX(3:3,{3,8,13,18,23,28})=0)*NOT(ISBLANK(INDEX(3:3,{3,8,13,18,23,28})))),"Yes", "No")
