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.