Maybe?
=INT(H2/10)
copied down?
Maybe?
=INT(H2/10)
copied down?
This one should work =IF(H2>=40,$J$18,IF(AND(H2<40,H2>=30),$J$19,IF(AND(H2<30,H2>=20),$J$20,IF(AND(H2<20,H2>=10),$J$21,0)))) . You can also replace the absolute values (40,30,20) with cells to make it more flexible if your criteria should change.
Hi Nesfin
The outcome of that is the same as NBVC suggestion!![]()
I didn't check it as it had a question mark but yes it indeed does work in this instance and it's much shorter![]()
Bookmarks