I am simply trying to associate the value in a cell with a range of numbers in the following formulas. Based on the range the cell value falls into, the result will be a number from, for example, 1 to 5. Neither of the following two formulas work. Any suggestions on how to get either one to work or should I be using a different one:
=IF(C26>-0.005,0,IF(C26>-0.02,-1,IF(C26>-0.04,-2,IF(C26<-0.041,-3,IF(C26<0.005,0,IF(C26<0.02,1,IF(C26<0.04,2,IF(C26>0.041,3,""))))))))
=INDEX({0;1;2;3;4},MATCH(D26,{0;0.005},{0.0051;0.019},{.02;.029},{.03;.049},{.05;.15}))
Thank you.
=IF(C26>-0.005,0,IF(C26>-0.02,-1,IF(C26>-0.04,-2,IF(C26<-0.041,-3,IF(C26<0.005,0,IF(C26<0.02,1,IF(C26<0.04,2,IF(C26>0.041,3,""))))))))
=INDEX({0;1;2;3;4},MATCH(D26,{0;0.005},{0.0051;0.019},{.02;.029},{.03;.049},{.05;.15}))
Thank you.