I'm having difficulty for some reason getting rid of my round function in this formula and figured someone on here could probably manage to do it in two seconds. Any help is appreciated. Below is the function;
=IF(COUNT(D25:X25)>=7,ROUND(((((SUM(SMALL(INDEX(D25:X25,LARGE(IF(D25:X25<>"",COLUMN(D25:X25)-COLUMN(D25)+1),7)):X25,{2,3,4,5,6})))/5)-36)*0.9),0),IF(COUNT(D25:X25)>=3,ROUND((AVERAGE(D25:X25)-36)*0.9,0),IF(X25>=0,"NEW","ERROR")))
I need to remove the round function so that my value contains additional digits.
Thanks!
Bookmarks