If a certain cell ( E29 for example ) contains a number between 0 and 5, I want the cell I'm programming to fill with CL1, however if E29 contains a number between 6 and 10 I want the cell I'm programming to fill with CL2, if E29 contains a number between 11 and 20, CL3 and up to CL7 - Please give me the exact formula at least up to CL2 - THANK U!!
Bookmarks