Chris,

It's C32 & E32 that must be populated for the formula to work, try this.

=IF(COUNT(C32,E52)=2,N34-SUM((P39/E52)+(P41/C32)+(P43/16.9)+N30)+P45/16.9,"")
--
Mike

When competing hypotheses are otherwise equal, adopt the hypothesis that
introduces the fewest assumptions while still sufficiently answering the
question.


"Chris" wrote:

Hello all
How can I get this formula to not return Div/0.
N32=N34-Sum((P39/E52)+(P41/C32)+(P43/16.9)+N30)+P45/16.9
It works ok so long as one of either P39, P41, P43, P45 has a value greater
than 0.
If all are "0" then it returns Div/0. if all are "0" the I need N32 to =
N34-N30
I hope you can follow this so you can help. ???????

Thanks
Chris