Please Help!

[fbro]

I think this would be easy for anyone good with excel; unfortunatly
that is not me! I am interested in writing a formula that will show
different variables once I have named the constant. For example, let
say I want to show 2 numbers that, added together, will equal th
number that I have entered. So in this matrix, I might enter 12 an
then excel would return 9/3 8/4 5/7 etc. I know that there are a
infinite number of combinations possible, so Im supposing Ill have t
assign a minimum and maximum value. Even so, I havent a clue as to ho
to write this.
Any ideas??

Thanks in advance!

 

[Frank Kabel]

Hi
one way :
enter your number in A1
in B1 enter
=A1
in B2 Enter
=IF(B1>0,B1-1,"")
and copy this down

in C1 enter
=IF(B1<>"",$A$1-B1,"")
and copy down