Hello All,

I am using the following formula to analyze data set A and then take an average and put it into the cell where the formula is:

=SUM((LOOKUP(ROUND(B397,0),{0,6,12,15,24},{1,2,3,4,5}))+((LOOKUP(ROUND(B399,0),{0,180,300,360,420},{1,2,3,4,5})))+(LOOKUP(ROUND(B396,0),{0,75,100,150,200},{1,2,3,4,5}))+(LOOKUP(ROUND(B398,0),{0,4,6,10,20},{5,4,3,2,1})))/4

The formula works perfectly except when I clear data set A, the above formula returns a value of "2". This happens when no data is present in the cells.

Thanks for the assistance with this.