Re: formula too long!

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" <Toppers@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:6A2754A7-399D-4BCF-8824-9C1EC7FC8E95@xxxxxxxxxxxxxxxx
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 (Insert>Name>Define...) 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" <phil2006.2abbhz_1151834401.8705@xxxxxxxxxxxxxxxxxxxxx> wrote
in
message news:phil2006.2abbhz_1151834401.8705@xxxxxxxxxxxxxxxxxxxxxxxx

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))*(POISSON(0,0.5*(C1-Sheet1!C52),FA

LSE))+(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
!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?action=getinfo&userid=35092
View this thread:
http://www.excelforum.com/showthread.php?threadid=557653






.