I am attaching another excel sheet with more detailed explanation. Thanks a lotCould you explain a bit more please, this is not quite clear to me
Works perfectly. Thanks a lottry in cell B4:copied to the right.Code:=INDEX({0.001,0.002,0.003,0.004,0.005,0},MATCH(B3,{0,200,300,400,500,1000}))+INT(B3/1000)/100
Check values less than 100A solution independent of an array of values
Good point. I suppose you found an answer ?Check values less than 100
The array-dependent one in msg#5!I suppose you found an answer ?