lokanathas
Registered User.
- Local time
- Today, 10:04
- Joined
- Aug 11, 2017
- Messages
- 23
=IIf( [Master]![MRPNew] >=1000,">1000",IIf( [Master]![MRPNew] >=700,"700-999",IIf( [Master]![MRPNew] >=600,"600-699",IIf( [Master]![MRPNew] >=500,"500-599",IIf( [Master]![MRPNew] >=400,"400-499",IIf( [Master]![MRPNew] >=300,"300-399",IIf( [Master]![MRPNew] >=200,"200-299",IIf( [Master]![MRPNew] >=100,"100-199",IIf( [Master]![MRPNew] >=0,"0-99",IIf( [Master]![MRPNew] <=-1000,">1000",IIf( [Master]![MRPNew] <=-700,"700-999",IIf( [Master]![MRPNew] <=-600,"600-699",IIf( [Master]![MRPNew] <=-500,"500-599",IIf( [Master]![MRPNew] <=-400,"400-499",IIf( [Master]![MRPNew] <=-300,"300-399",IIf( [Master]![MRPNew] <=-200,"200-299",IIf( [Master]![MRPNew] <=-100,"100-199",IIf( [Master]![MRPNew] <=-0,"0-99","NA"))))))))))))))))))
i heard that only 7 iif is possible, kindly suggest the alternate solution for the above slabbing.
i heard that only 7 iif is possible, kindly suggest the alternate solution for the above slabbing.