This is one of those instances where parsing the formula for patterns raises
some questions.

There is a pattern: Poisson({n},(+),)*(Poisson(0,(-),) which holds for n=
1,2,3,4, and 7.

{n}=2 is repeated. Is that intentional?

Also, there is a break in the pattern at n=5 and n=6 where you have
Poisson(5,(+)) * Poisson (6,(-)). Is that intentional?

And, finally, at the end, you have a Poisson(2,(+))*Poisson(1,(-)). Is that
intentional?

I would address this as follows:

In a separate cell, enter the Poisson(0,(-)) formula.

Put the n values in a column and the corr. Poisson(n,(+)) in the adjacent
column.

Finally, put the Poisson(n,(+))-Poisson(0,(-)) calculations in the next
adjacent column.

Add everything up in a cell below the range that contains the above
analysis.

The result will be dramatically transaparent, easy to read, understand,
debug, and maintain.

--
Regards,

Tushar Mehta
www.tushar-mehta.com
Excel, PowerPoint, and VBA add-ins, tutorials
Custom MS Office productivity solutions

In article ,
says...

I have the following formula:
(POISSON(1,0.5*(C1+Sheet1!C52),FALSE))*(POISSON(0, 0.5*(C1-Sheet1!C52),FALSE))+(POISSON(2,0.5*(C1+Sheet1!C52) ,FALSE))*(POISSON(0,0.5*(C1-Sheet1!C52),FALSE))+(POISSON(2,0.5*(C1+Sheet1!C52) ,FALSE))*(POISSON(0,0.5*(C1-Sheet1!C52),FALSE))+(POISSON(3,0.5*(C1+Sheet1!C52) ,FALSE))*(POISSON(0,0.5*(C1-Sheet1!C52),FALSE))+(POISSON(4,0.5*(C1+Sheet1!C52) ,FALSE))*(POISSON(0,0.5*(C1-Sheet1!C52),FALSE))+(POISSON(5,0.5*(C1
+Sheet1!C52),FALSE))*(POISSON(6,0.5*(C1-Sheet1!C52),FALSE))+(POISSON(7,0.5*(C1+Sheet1!C52) ,FALSE))*(POISSON(0,0.5*(C1-Sheet1!C52),FALSE))+(POISSON(2,0.5*(C1+Sheet1!C52) ,FALSE))*(POISSON(1,0.5*(C1-Sheet1!C52),FALSE))


and need to add more, is there anyway I can reduce the size because i
am being told it is too long!

Thanks


--
phil2006
------------------------------------------------------------------------
phil2006's Profile: http://www.excelforum.com/member.php...o&userid=35092
View this thread: http://www.excelforum.com/showthread...hreadid=557653