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.

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" <vjeevar.22xe4a_1139427301.0449@excelforum-nospam.com> wrote in
message news:vjeevar.22xe4a_1139427301.0449@excelforum-nospam.com...
>
> 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
>

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" <vjeevar.22xe4a_1139427301.0449@excelforum-nospam.com> wrote in
> message news:vjeevar.22xe4a_1139427301.0449@excelforum-nospam.com...
> >
> > 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
> >
>
>
>