Hi salafichennai!
Welcome to the forum
Use the following formula in G2, and copy down:
=IF(H2<10,"None",IF(H2<20,"Low",IF(H2<30,"Medium",IF(H2<40,"High","Critical"))))
Don't forget to click the little star to the left of this post if you feel I helped!
Bookmarks