N
namphong
Hi every body,
It would be vey nice of you if you can help me resolve this problem in
using VBA code. In fact, I try to obtain all of possible values for
cells (V2,W2,X2,Y2,Z2,AA2,AB2) given that cell V23 =2%.
In other terms, I have to resolve this program:
V2+W2+X2+Y2+Z2+AA2+AB2 =100%
given that:
V23 =2% et
-50% < = V2,W2,X2,Y2,Z2,AA2,AB2 <=100%
I hope that you can help me. Thanks in advance
Titi
Attachment filename: varhelp.zip
Download attachment: http://www.excelforum.com/attachment.php?postid=429497
It would be vey nice of you if you can help me resolve this problem in
using VBA code. In fact, I try to obtain all of possible values for
cells (V2,W2,X2,Y2,Z2,AA2,AB2) given that cell V23 =2%.
In other terms, I have to resolve this program:
V2+W2+X2+Y2+Z2+AA2+AB2 =100%
given that:
V23 =2% et
-50% < = V2,W2,X2,Y2,Z2,AA2,AB2 <=100%
I hope that you can help me. Thanks in advance
Titi
Attachment filename: varhelp.zip
Download attachment: http://www.excelforum.com/attachment.php?postid=429497