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

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

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