ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Iteration programing (https://www.excelbanter.com/excel-programming/290074-iteration-programing.html)

namphong

Iteration programing
 
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
---
Message posted from http://www.ExcelForum.com/



All times are GMT +1. The time now is 05:18 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com