From: Fred Smith on 29 Apr 2010 17:28 And to make it easier to follow, get rid of the unneeded Sum function and parentheses: =IF(COUNT(C32,E52)=2,N34-P39/E52+P41/C32+P43/16.9+N30+P45/16.9,"") Fred "Mike H" wrote in message news:20BF41EB-84BD-4E0A-A56A-C5D481BFC0AF(a)microsoft.com...> 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 From: "David Biddulph" groups [at] on 29 Apr 2010 19:53 I think you've got some signs reversed compared with what the OP was asking for, Fred. Try =IF(COUNT(C32,E52)=2,N34-P39/E52-P41/C32-P43/16.9-N30+P45/16.9,"") -- David Biddulph "Fred Smith" wrote in message news:uEB6#L#5KHA.4940(a)TK2MSFTNGP05.phx.gbl...> And to make it easier to follow, get rid of the unneeded Sum function and > parentheses: > =IF(COUNT(C32,E52)=2,N34-P39/E52+P41/C32+P43/16.9+N30+P45/16.9,"") > > Fred > > "Mike H" wrote in message > news:20BF41EB-84BD-4E0A-A56A-C5D481BFC0AF(a)microsoft.com... >> 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 > First  |  Prev  |