math applications and formulas

L

Linda

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
 
T

Tom Ogilvy

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?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

math applications and formulas 1
If function and math formulas 3
Math formula help 5
Repeating a row other than the 1st row as the header row in a table from next page 1
Remove Identical words 0
Need some PWA help 0
Need Help with a VBA subroutine 0
Arrays and scattered cell values or another way? 16

Top