Hello excel community, I have struggled to develop 1 conditional formula for multiples as indicated in the attached excel sheet. Kindly please help with that. Thanks in advance for your help
Attachments

9.2 KB Views: 9
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 arraydependent one in msg#5!I suppose you found an answer ?