Forum Discussion
"IF" formula?
Hi, hoping someone can help me. I am trying to make a sheet that reads analysis-results for me, i have different parameters within different intervals. The result varies between different interva...
Hi Elisabeth,
I'd suggest not to use strings to define the ranges but upper limits for them like
When the formula which returns in which range the result is could be
=IF(ISBLANK($B4),"No Data",INDEX($B$2:$F$2,0,MIN(IFNA(MATCH(H4,$B4:$F4,1),0)+1,5)))
To color the class we may apply conditional formatting using similar formulas for the rules (one color - one rule) like
=INDEX($B$1:$F$1,0,IFNA(MATCH(H4,$B4:$F4,1),0)+1)=2
for green color.
Sample is attached