Use result of one cell to affect another

[Closed]
Report
-
Posts
190
Registration date
Sunday April 12, 2009
Status
Member
Last seen
February 16, 2010
-
Hello,
I want to add or subtract an amount in my end results column based on data in my other columns.

In other words
if L52> = 0, then I want to make c52 less by .1 (which would be slightly better since smaller is better.

c52 has already averaged d52 : k52, but I don't want to average in any more values , I just want to hurt or help the derived average by a bit depending on if these other values are above or below a certain threshhold (such as 0).

So I might need to embed the average formula in the if formula, or vice versa, maybe make a new column?

in cell c52 is the formula average d52:k52
but I want that result to be improved or reduced by an amount if certain other criteria are "good" or "bad"
but the other cells' values are mathematically incompatible with the average (or are text cells)

thanks

1 reply

Posts
190
Registration date
Sunday April 12, 2009
Status
Member
Last seen
February 16, 2010
155
Try this formula in Cell C2 .................

=IF(L52>=0,AVERAGE(D52:K52),"")