Prev: unlock frozen cells
Next: How do I create a drop box in Excel to show a calendar?
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" <MikeH(a)discussions.microsoft.com> 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" <fsmith11(a)yahooo.com> 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" <MikeH(a)discussions.microsoft.com> 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  | 
Pages: 1 2
Prev: unlock frozen cells
Next: How do I create a drop box in Excel to show a calendar?