Trouble with variance and conditional formating

[ed.ayers315]

Here is a data set I am using. I need to show the percentage of variance, positive and negative. In the last column, you can see the result of this formula is wack. That column also has conditional formatting, DataBar. I need the databar to visually represent the actual percentage above or below the surv usage target. The formula in that column is <iferror(if(an11<0,am11 al11-1,(al11="" am11-1)),"")="">
</iferror(if(an11<0,am11>
<iferror(if(an11<0,am11 al11-1,(al11="" am11-1)),"")="">iferror(if(an11< 0,am11 al11-1,(al11="" am11-1)),"")=""
AN11 is Per Surv
AM11 is Periods current average

Any direction would be appreciated!

[TABLE="width: 1457"]
<tbody>[TR]
[TD]PER SURV[/TD]
[TD]PERIOD'S CURRENT AVG[/TD]
[TD]AVG VARIANCE TO SURVEY[/TD]
[TD]JAN: 2018[/TD]
[TD]FEB: 2018[/TD]
[TD]MAR: 2018[/TD]
[TD]APR: 2018[/TD]
[TD]MAY: 2018[/TD]
[TD]JUN: 2018[/TD]
[TD]JUL: 2017[/TD]
[TD]AUG: 2017[/TD]
[TD]SEP: 2017[/TD]
[TD]OCT: 2017[/TD]
[TD]NOV: 2017[/TD]
[TD]DEC: 2017[/TD]
[TD][/TD]
[TD]EASY VIEW DATA
BARS
% VARIANCE[/TD]
[/TR]
[TR]
[TD="align: right"]156.6[/TD]
[TD="align: right"]181.9[/TD]
[TD="align: right"]25.3[/TD]
[TD="align: right"]193.4[/TD]
[TD="align: right"]187.8[/TD]
[TD="align: right"]160.2[/TD]
[TD="align: right"]199.5[/TD]
[TD="align: right"]192.5[/TD]
[TD="align: right"]206.2[/TD]
[TD="align: right"]170.1[/TD]
[TD="align: right"]195.2[/TD]
[TD="align: right"]182.4[/TD]
[TD="align: right"]197.7[/TD]
[TD="align: right"]212.2[/TD]
[TD="align: right"]85.4[/TD]
[TD][/TD]
[TD]618.4%[/TD]
[/TR]
[TR]
[TD="align: right"]30.0[/TD]
[TD="align: right"]38.5[/TD]
[TD="align: right"]8.5[/TD]
[TD="align: right"]42.5[/TD]
[TD="align: right"]41.4[/TD]
[TD="align: right"]27.0[/TD]
[TD="align: right"]23.2[/TD]
[TD="align: right"]1.8[/TD]
[TD="align: right"]41.9[/TD]
[TD="align: right"]42.6[/TD]
[TD="align: right"]43.1[/TD]
[TD="align: right"]35.2[/TD]
[TD="align: right"]53.9[/TD]
[TD="align: right"]52.1[/TD]
[TD="align: right"]57.2[/TD]
[TD][/TD]
[TD]353.7%[/TD]
[/TR]
[TR]
[TD="align: right"]159.9[/TD]
[TD="align: right"]165.3[/TD]
[TD="align: right"]5.4[/TD]
[TD="align: right"]173.4[/TD]
[TD="align: right"]163.5[/TD]
[TD="align: right"]133.1[/TD]
[TD="align: right"]174.0[/TD]
[TD="align: right"]160.2[/TD]
[TD="align: right"]163.9[/TD]
[TD="align: right"]160.7[/TD]
[TD="align: right"]54.8[/TD]
[TD="align: right"]163.4[/TD]
[TD="align: right"]197.9[/TD]
[TD="align: right"]172.8[/TD]
[TD="align: right"]265.9[/TD]
[TD][/TD]
[TD]2934.3%[/TD]
[/TR]
[TR]
[TD="align: right"]7.9[/TD]
[TD="align: right"]9.8[/TD]
[TD="align: right"]1.9[/TD]
[TD="align: right"]8.3[/TD]
[TD="align: right"]9.6[/TD]
[TD="align: right"]9.7[/TD]
[TD="align: right"]10.5[/TD]
[TD="align: right"]11.0[/TD]
[TD="align: right"]8.9[/TD]
[TD="align: right"]8.5[/TD]
[TD="align: right"]6.4[/TD]
[TD="align: right"]11.6[/TD]
[TD="align: right"]13.1[/TD]
[TD="align: right"]11.8[/TD]
[TD="align: right"]8.2[/TD]
[TD][/TD]
[TD]418.5%[/TD]
[/TR]
[TR]
[TD="align: right"]0.5[/TD]
[TD="align: right"]0.5[/TD]
[TD="align: right"]0.0[/TD]
[TD="align: right"]1.2[/TD]
[TD="align: right"]0.1[/TD]
[TD="align: right"]0.1[/TD]
[TD="align: right"]1.4[/TD]
[TD="align: right"]0.4[/TD]
[TD="align: right"]0.4[/TD]
[TD="align: right"]0.1[/TD]
[TD="align: right"]0.1[/TD]
[TD="align: right"]0.9[/TD]
[TD="align: right"]0.7[/TD]
[TD="align: right"]0.2[/TD]
[TD="align: right"]0.5[/TD]
[TD][/TD]
[TD]1168.0%[/TD]
[/TR]
[TR]
[TD="align: right"]2.4[/TD]
[TD="align: right"]2.5[/TD]
[TD="align: right"]0.0[/TD]
[TD="align: right"]0.3[/TD]
[TD="align: right"]2.7[/TD]
[TD="align: right"]2.9[/TD]
[TD="align: right"]0.7[/TD]
[TD="align: right"]3.0[/TD]
[TD="align: right"]2.1[/TD]
[TD="align: right"]3.4[/TD]
[TD="align: right"]2.8[/TD]
[TD="align: right"]2.3[/TD]
[TD="align: right"]2.6[/TD]
[TD="align: right"]1.9[/TD]
[TD="align: right"]5.2[/TD]
[TD][/TD]
[TD]6776.2%[/TD]
[/TR]
[TR]
[TD="align: right"]5.5[/TD]
[TD="align: right"]2.5[/TD]
[TD="align: right"](2.9)[/TD]
[TD="align: right"]0.0[/TD]
[TD="align: right"]0.9[/TD]
[TD="align: right"]4.3[/TD]
[TD="align: right"]5.4[/TD]
[TD="align: right"]10.6[/TD]
[TD="align: right"]9.1[/TD]
[TD="align: right"]0.0[/TD]
[TD="align: right"]0.0[/TD]
[TD="align: right"]0.0[/TD]
[TD="align: right"]0.0[/TD]
[TD="align: right"]0.0[/TD]
[TD="align: right"]0.0[/TD]
[TD][/TD]
[TD]-185.9%[/TD]
[/TR]
</tbody>[/TABLE]


</iferror(if(an11<0,am11>