| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Reverse Sum
Does anyone know if there is a way of having a reverse sum calculate in excel? For example, instead of 1+1+2=4, I would like to type '4' into a cell and have options come back such as 2+2, 1+1+2, 3+1... Thanks. -- vjeevar ------------------------------------------------------------------------ vjeevar's Profile: http://www.excelforum.com/member.php...o&userid=21474 View this thread: http://www.excelforum.com/showthread...hreadid=510199 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Reverse Sum
For a number like 50, are you looking to list all 204,226 "Integer
Partitions", or just a few at random? -- Dana DeLouis Windows XP, Office 2003 "vjeevar" wrote in message ... Does anyone know if there is a way of having a reverse sum calculate in excel? For example, instead of 1+1+2=4, I would like to type '4' into a cell and have options come back such as 2+2, 1+1+2, 3+1... Thanks. -- vjeevar ------------------------------------------------------------------------ vjeevar's Profile: http://www.excelforum.com/member.php...o&userid=21474 View this thread: http://www.excelforum.com/showthread...hreadid=510199 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Reverse Sum
Is that really the number of partitions, or were you just making a point? If
so, how did you calculate it? "Dana DeLouis" wrote: For a number like 50, are you looking to list all 204,226 "Integer Partitions", or just a few at random? -- Dana DeLouis Windows XP, Office 2003 "vjeevar" wrote in message ... Does anyone know if there is a way of having a reverse sum calculate in excel? For example, instead of 1+1+2=4, I would like to type '4' into a cell and have options come back such as 2+2, 1+1+2, 3+1... Thanks. -- vjeevar ------------------------------------------------------------------------ vjeevar's Profile: http://www.excelforum.com/member.php...o&userid=21474 View this thread: http://www.excelforum.com/showthread...hreadid=510199 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to Reverse Contents in an Excel cell (Text or a Number) | Excel Worksheet Functions | |||
| Reverse a Macro - works like back button | Excel Discussion (Misc queries) | |||
| reverse data | Excel Discussion (Misc queries) | |||
| Printing same table on reverse side of all pages. | Excel Discussion (Misc queries) | |||
| How 2 reverse order of columns | Excel Discussion (Misc queries) | |||
Linear Mode
