I need a formula to be contingent upon a number in a different cell.

[katielux]

This is my first post on any help forum ever!

I am calculating grain moisture, using this information to adjust my grain bushel amount.

I need my formula to deliver a 0.0 if the moisture is lower than 13.0. If it is higher than 13.0 I need the following function performed: =SUM(F129-13)/100*K129

If the moisture is lower than 13.00 the result would be negative. I don't need to make any adjustments if the result is negative.

I tried formatting the cells like this: #,##0.00;"0.00" and this delivers a zero in the case of a negative, but this cell is used in another formula and the second formula is using the actual result not the 0.

i have attached a portion of my data as an example. I am using Excell 2007.

I am trying very hard to provide accurate information. Please help!! Thank you!

Katie

[BadlySpelledBuoy]

Not sure if I've understood your requirement correctly, but, the way I read it is, if the value in column F is less than 13 then the value in column L should be 0.0. If the value in column F is greater than or equal to 13 then the value in column L should be the result of the formula you posted above.

IF, this is the case then try =IF(F2<13,0,SUM(F2-13)/100*K2) in cell L2 and copy down.

The thing that makes me think this is NOT what you actually require is the inconsistent formulas in column L in your example workbook.

[katielux]

This is exactly what I need! Thank you!

I think my formulas were inconsistent because I was testing out a few things and should have fixed it.

Thanks for your help.

Katie

[BadlySpelledBuoy]

My pleasure Katie. Happy to help.

Feel free to mark the thread as SOLVED if you're happy you have you're solution.

BSB.

[newdoverman]

The math in column N is correct. Even though a value of 0 is shown in in column L when negative, that is only formatting but the real value is still there and is being calculated correctly. The actual value in L2 is -4.43733333333334 even though 0.00 is shown. You can test this yourself by changing temporarily the formatting of L2 to GENERAL to make the real value of L2 appear. Notice that the calculation doesn't change in N2 the cell that is dependent upon the value in L2.

[katielux]

This is true, but in this specific case if the number in column L is negative I want it to have no effect on column N. The formula in N is =SUM(K12-L12-M12), so I am taking column L, which is the amount of bushels I lose from moisture shrinkage, and reducing N. If the the negative value in L were to be considered I would effectively be adding back grain that doesn't exist. I am reducing my bushel amount based on the grain drying to the correct moisture (in this case 13.00).