If statement required for a cell range

[scottb]

What I want to say is:

If C36, C37, C38 or C39 contain a 0 then put 0 if not continue with the the formulae

I have this but I know its not right as this is a sum:

=IF(C36:C39=0,0,ROUNDUP((C36/C37)+(C38/C39),0))

Anyone help?? thanks in advance.

[darkyam]

Hi, Scott. Please take a minute to read the forum rules and amend your title in accordance with rule 1. Thanks.

[scottb]

Apologies. I hope this worded correctly.

Thanks

[darkyam]

=if(countif(c36:c39,"=0"),0,roundup((c36/c37)+(c38/c39),0))

[jrdnoland]

Another way to do it:

=if(c36=0,0,if(c37=0,0,if(c38=0,0,if(c39=0,0,roundup((c36/c37)+(c38/c39),0)))))