[Allowance Formula] More than one IIF Conditions Function

Example:
1）IIF(CATE="SALES",AW*3,...)
2）IIF(CATE="PURCHASE",AW*5,...)
3）IIF(CATE="ADMIN",AW*2,...)


Combine Formula:-

IIF(CATE="SALES",AW*3,IIF(CATE="PURCHASE",AW*5,IIF(CATE="ADMIN",AW*2,0)))