Running out of room,,any way to shortin this formula ?
=IF(AS13>=7,HLOOKUP(B13,$AD$13:$AL$20,8),IF(AS13>=6,HLOOKUP(B13,$AD$13:$AL$20,7),IF(AS13>=5,HLOOKUP(B13,$AD$13:$AL$20,6),IF(AS13>=4,HLOOKUP(B13,$AD$13:$AL$20,5),IF(AS13>=3,HLOOKUP(B13,$AD$13:$AL$20,4),IF(AS13>=2,HLOOKUP(B13,$AD$13:$AL$20,3),IF(AS13>=1,HLOOKUP(B13,$AD$13:$AL$20,2),"0.00")))))))
=IF(AS13>=7,HLOOKUP(B13,$AD$13:$AL$20,8),IF(AS13>=6,HLOOKUP(B13,$AD$13:$AL$20,7),IF(AS13>=5,HLOOKUP(B13,$AD$13:$AL$20,6),IF(AS13>=4,HLOOKUP(B13,$AD$13:$AL$20,5),IF(AS13>=3,HLOOKUP(B13,$AD$13:$AL$20,4),IF(AS13>=2,HLOOKUP(B13,$AD$13:$AL$20,3),IF(AS13>=1,HLOOKUP(B13,$AD$13:$AL$20,2),"0.00")))))))