The attached file has column M and AL and AM. I want to automate what to categorize column M based on what contents columns AL and AM have...
1. If AL and AM both have numbers - less than or greater than zero - than populate the corresponding cell in column M with "NILL/PIM" (without the ")
2. If only AL has numbers - less than or greater than zero - than populate the corresponding cell in column M with "Standard"
3. If only AM has numbers - less than or greater than zero - than populate the corresponding cell in column M with "PIM"
4. If both AL and AM have a zero, than leave corresponding cell in column M empty , no category...
Note: the cells where there is no value less than or greater than zero, there will be a zero populated...
Bookmarks