Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
A kind of what-if problem - Please help
I have four cells :
A1 A2 A3 A4, A5, A6 etc A3 value is based on a complex formula using A1 and A2. My problem is : I want A4, A5, A6, A7 to tell me the valueof A3 when A1 and A2 are changed to various values. Thanks a million Denis |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
A kind of what-if problem - Please help
more info?
"Denis L. Menezes" wrote in message ... I have four cells : A1 A2 A3 A4, A5, A6 etc A3 value is based on a complex formula using A1 and A2. My problem is : I want A4, A5, A6, A7 to tell me the valueof A3 when A1 and A2 are changed to various values. Thanks a million Denis |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
A kind of what-if problem - Please help
Dim varr1, varr2
Dim i as long, j as long, k as long Dim Varr1 = Array(1,100,20,31,54) Varr2 = Array(16,22,39) k = 0 for i = 1 to 5 Range("A1").Value = varr1(i) for j = 1 to 3 Range("A2").Value = varr2(j) Application.Calculate Range("A4").Offset(k,0).Value = Range("A3").Value k = k + 1 Next Next -- Regards, Tom Ogilvy "Denis L. Menezes" wrote in message ... I have four cells : A1 A2 A3 A4, A5, A6 etc A3 value is based on a complex formula using A1 and A2. My problem is : I want A4, A5, A6, A7 to tell me the valueof A3 when A1 and A2 are changed to various values. Thanks a million Denis |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
A kind of what-if problem - Please help
Or use the DataTable command. Look in Help for details. Write again if you
have problems. -- Regards, Niek Otten Microsoft MVP - Excel "Tom Ogilvy" wrote in message ... Dim varr1, varr2 Dim i as long, j as long, k as long Dim Varr1 = Array(1,100,20,31,54) Varr2 = Array(16,22,39) k = 0 for i = 1 to 5 Range("A1").Value = varr1(i) for j = 1 to 3 Range("A2").Value = varr2(j) Application.Calculate Range("A4").Offset(k,0).Value = Range("A3").Value k = k + 1 Next Next -- Regards, Tom Ogilvy "Denis L. Menezes" wrote in message ... I have four cells : A1 A2 A3 A4, A5, A6 etc A3 value is based on a complex formula using A1 and A2. My problem is : I want A4, A5, A6, A7 to tell me the valueof A3 when A1 and A2 are changed to various values. Thanks a million Denis |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Different kind of rounding | Excel Discussion (Misc queries) | |||
Hi Everyone! Im a Student so please be kind... | Charts and Charting in Excel | |||
Is this kind of count possible?... | Excel Worksheet Functions | |||
Help what kind of formula? | New Users to Excel | |||
What kind of Formula?? | Excel Discussion (Misc queries) |