Use result of one cell to affect another

Closed
tlc - May 3, 2009 at 10:01 AM
mubashir aziz Posts 190 Registration date Sunday April 12, 2009 Status Member Last seen February 16, 2010 - May 6, 2009 at 12:52 AM
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 response

mubashir aziz Posts 190 Registration date Sunday April 12, 2009 Status Member Last seen February 16, 2010 166
May 6, 2009 at 12:52 AM
Try this formula in Cell C2 .................

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


0