Solve : What formula would be used to solve this??

1.	Solve : What formula would be used to solve this??
Answer» Hey guyz, me STUCK here in EXCEL to solve this issue. Will someone will help me to GET out of this? Here is the example; there is column named Bucket which include Current, OEAM, Sub-Standard, Doubfull & Loss. Whereas Current bucket start from -1 & goes to -200, OEAM bucket is from 1-59, Substandard bucket is from 60-79, Doubfull bucket is from 80-179 & Loss bucket is from 180-209. Im stuck as I WANT that when I change the bucket numerically for example i change the value 59 into 60 so the bucket changes from OEAM to SUb-standard.So what will be the formula so that bucket changed automatically while I change the value? Do help me at the earliest.

Discussion