| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
formula too long!
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 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Can't add 7th IF statement to long formula. | Excel Worksheet Functions | |||
| More than 3 conditional formats? | Excel Discussion (Misc queries) | |||
| Formula Problem - interrupted by #VALUE! in other cells!? | Excel Worksheet Functions | |||
| Formula too long | Excel Discussion (Misc queries) | |||
| Date & Time | New Users to Excel | |||
Threaded Mode
