Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
math applications and formulas
I need help with the following math application:
I have two rows of values. Values in row 2 will change if the values in row 1 change. The change pattern is the average of those values in row 2 *3+3 when the values in row 1=0. I tried the formula: Please help. Thank you, Linda |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
math applications and formulas
Linda,
Was there more you wanted to post? Is it the formula you are asking for? "Linda" wrote: I need help with the following math application: I have two rows of values. Values in row 2 will change if the values in row 1 change. The change pattern is the average of those values in row 2 *3+3 when the values in row 1=0. I tried the formula: Please help. Thank you, Linda |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
math applications and formulas
You can't have both a value and a formula in a cell. If you want the value
in row 2 to change when the value in row1 in the same column changes, then you will need to use a macro. What causes the values in row 1 to change. Is it a calculation, a DDE link, a manual edit, VBA code, some other trigger? -- Regards, Tom Ogilvy "Linda" wrote: I need help with the following math application: I have two rows of values. Values in row 2 will change if the values in row 1 change. The change pattern is the average of those values in row 2 *3+3 when the values in row 1=0. I tried the formula: Please help. Thank you, Linda |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Math formulas possible with overstrike characters? | Excel Discussion (Misc queries) | |||
Accounting Applications using Array Formulas | Excel Discussion (Misc queries) | |||
If function and math formulas | Excel Programming | |||
My formulas do not calculate in some Excel applications - help! | Excel Worksheet Functions | |||
Excel Math formulas | Excel Discussion (Misc queries) |