If Statement Issue

[stockviper]

Hello all I am having an issue with a formula in my spreadsheet. I have run out of thought on my formula. Background. I have stores I'm looking at for periods of time for sales comp. That information is in cells A-K. Column L is a pretty straight forward formula to tell me if the store is doing better or worse that it's comparable quarter. The problem I am having is in Column M, N and O. I'm missing some condition because if column M turns positive the factor in column N will turn negative and therefore give the store a positive value which can't happen, it has to be a negative value.

COL A	COL B	COL C	COL D	COL E	COL F	COL G	COL H	COL I	COL J	COL K
1		470,835.30	436,847.15	401,435.36	1,309,117.80		460,784.02	422,740.36	369,567.54	1,253,091.93

This is raw data.

Formulas in renaming column l

COL L =IFERROR(F12/K12-1,0) COL M =(SUM($C$12:$E$971)-SUM($H$12:$J$971))/SUM($H$12:$J$971) COL N =IF(L12>0,0,IF(L12>M12,1,+L12/M12)) COL O =IF(+L12<=-0.1,-0.1,IF(+N12*$O$3<=-0.1,L12,+N12*$O$3)) COL P =+O12-$O$3 Cell $O3 is -2.88% If someone could please help.

 

[stockviper]

All my data starts on row 12. And the formula in Column M is just a sum of a total set of 900 plus locations.