You are right, my P0 should be
=(POISSON(0,0.5*(C1-Sheet1!C52),FALSE))
--
HTH
Bob Phillips
(replace somewhere in email address with gmail if mailing direct)
"Toppers" wrote in message
...
Bob,
The second half of the formula uses C1-Sheet1!C52 so (I
believe)
using your solution will give an incorrect result as in your response both
portions are using C1+Sheet1!C52.
"Bob Phillips" wrote:
To start I would create a name (InsertNameDefine...) of say Half with
a
refers to value of
=0.5*(C1+Sheet1!C52)
then another for one formula of say P0 with a refers to value of
=(POISSON(0,Half,FALSE))
and then use
(POISSON(1,0.Half,FALSE))*P0+
(POISSON(2,0.Half,FALSE))*P0+
(POISSON(2,0.Half,FALSE))*P0+
(POISSON(3,0.Half,FALSE))*P0+
(POISSON(4,0.Half,FALSE))*P0+
(POISSON(5,0.Half,FALSE))*(POISSON(6,0.5*(C1-Sheet1!C52),FALSE))+
(POISSON(7,0.Half,FALSE))*P0+
(POISSON(2,0.Half,FALSE))*(POISSON(1,0.5*(C1-Sheet1!C52),FALSE))
or take it further and replace FALSE by 0
(POISSON(1,0.Half,0))*P0+
(POISSON(2,0.Half,0))*P0+
(POISSON(2,0.Half,0))*P0+
(POISSON(3,0.Half,0))*P0+
(POISSON(4,0.Half,0))*P0+
(POISSON(5,0.Half,0))*(POISSON(6,0.5*(C1-Sheet1!C52),0))+
(POISSON(7,0.Half,0))*P0+
(POISSON(2,0.Half,0))*(POISSON(1,0.5*(C1-Sheet1!C52),0))
--
HTH
Bob Phillips
(replace somewhere in email address with gmail if mailing direct)
"phil2006" wrote
in
message ...
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),FA
LS
E))+(POISSON(2,0.5*(C1+Sheet1!C52),FALSE))*(POISSO N(0,0.5*(C1-Sheet1!C52),FA
LSE))+(POISSON(3,0.5*(C1+Sheet1!C52),FALSE))*(POIS SON(0,0.5*(C1-Sheet1!C52),
FALSE))+(POISSON(4,0.5*(C1+Sheet1!C52),FALSE))*(PO ISSON(0,0.5*(C1-Sheet1!C52
),FALSE))+(POISSON(5,0.5*(C1+Sheet1!C52),FALSE))*( POISSON(6,0.5*(C1-Sheet1
!C
52),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-Shee
t1!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