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
Configuration: Windows XP Firefox 3.0.10
Acer aspire one not starting up Acer aspire one system restore Acer erecovery aspire one Acer one zg5 Adding more than one cell in spreadsheet Antec performance one mini 182se Count the values of one cell based on the value of another Enable acer aspire one 3g Excel - if cell < 100 turn cell red Excel 2007 combine formulas from multiple cells into one cell Free info guide on how to assign data from one cell in excel to another cell on another sheet How can i assighn data from one cell in excel to another cell on another sheet How to hook up two computer to one modem How to use two conditional formatting in one cell Mcro to compare excel text in one column with a cell range Noise coming from one headphone Shock proof cell phone flip This could be the result of a damage disk, a failed download or a virus