Limitation on rules in power query

aam1932

Board Regular
Joined
Jun 2, 2010
Messages
175
Hai,

Can i know that how many number of rules maximum in power query? I have some rules in power query as below, the problem the query not functioning if i add few more query to this.
Really need your help and how to increase numbers rules or any other alternative.

Thank you in advance

if
[Account Code]="10100"then"01. BS - Fixed Asset - Cost|||"else if
[Account Code]="10101"then"01. BS - Fixed Asset - Cost|||"else if
[Account Code]="10200"then"01. BS - Fixed Asset - Cost|||"else if
[Account Code]="10210"then"01. BS - Fixed Asset - Cost|||"else if
[Account Code]="10300"then"01. BS - Fixed Asset - Cost|||"else if
[Account Code]="10400"then"01. BS - Fixed Asset - Cost|||"else if
[Account Code]="10550"then"04. BS - Investment fund size|07. Properties||"else if
[Account Code]="10551"then"04. BS - Investment fund size|07. Properties||"else if
[Account Code]="10555"then"01. BS - Fixed Asset Land & Building|||"else if
[Account Code]="10560"then"01. BS - Fixed Asset Land & Building|||"else if
[Account Code]="11100"then"03. BS - Fixed Asset - Accum Dep|||"else if
[Account Code]="11101"then"03. BS - Fixed Asset - Accum Dep|||"else if
[Account Code]="11150"then"03. BS - Fixed Asset - Accum Dep|||"else if
[Account Code]="11200"then"03. BS - Fixed Asset - Accum Dep|||"else if
[Account Code]="11201"then"03. BS - Fixed Asset - Accum Dep|||"else if
[Account Code]="11250"then"03. BS - Fixed Asset - Accum Dep|||"else if
[Account Code]="11260"then"03. BS - Fixed Asset - Accum Dep|||"else if
[Account Code]="11300"then"03. BS - Fixed Asset - Accum Dep|||"else if
[Account Code]="11350"then"03. BS - Fixed Asset - Accum Dep|||"else if
[Account Code]="11400"then"03. BS - Fixed Asset - Accum Dep|||"else if
[Account Code]="11450"then"03. BS - Fixed Asset - Accum Dep|||"else if
[Account Code]="11500"then"04. BS - Investment fund size|07. Properties||"else if
[Account Code]="11505"then"01. BS - Fixed Asset Land & Building|||"else if
[Account Code]="11550"then"04. BS - Investment fund size|07. Properties||"else if
[Account Code]="11560"then"01. BS - Fixed Asset Land & Building|||"else if
[Account Code]="11600"then"03. BS - Fixed Asset - Accum Dep|||"else if
[Account Code]="11650"then"03. BS - Fixed Asset - Investment Property|||"else if
[Account Code]="11660"then"03. BS - Fixed Asset - Accum Dep|||"else if
[Account Code]="12020"then"01. BS - Fixed Asset - Cost|||"else if
[Account Code]="12030"then"03. BS - Fixed Asset - Investment Property|||"else if
[Account Code]="12200"then"04. BS - Investment fund size|02. Secured / Unsecured Credit Facilities||"else if
[Account Code]="12201"then"04. BS - Investment fund size|02. Secured / Unsecured Credit Facilities||"else if
[Account Code]="12210"then"04. BS - Investment fund size|05. Quoted Share||"else if
[Account Code]="12211"then"04. BS - Investment fund size|05. Quoted Share||"else if
[Account Code]="12212"then"04. BS - Investment fund size|05. Quoted Share||"else if
[Account Code]="12300"then"04. BS - Investment fund size|02. Secured / Unsecured Credit Facilities||"else if
[Account Code]="12301"then"04. BS - Investment fund size|02. Secured / Unsecured Credit Facilities||"else if
[Account Code]="12302"then"04. BS - Investment fund size|02. Secured / Unsecured Credit Facilities||"else if
[Account Code]="12351"then"04. BS - Investment fund size|01. Low Risk Assets||"else if
[Account Code]="12352"then"04. BS - Investment fund size|01. Low Risk Assets||"else if
[Account Code]="12353"then"04. BS - Investment fund size|02. Secured / Unsecured Credit Facilities||"else if
[Account Code]="12354"then"04. BS - Investment fund size|02. Secured / Unsecured Credit Facilities||"else if
[Account Code]="12355"then"04. BS - Investment fund size|02. Secured / Unsecured Credit Facilities||"else if
[Account Code]="12356"then"04. BS - Investment fund size|02. Secured / Unsecured Credit Facilities||"else if
[Account Code]="12357"then"04. BS - Investment fund size|02. Secured / Unsecured Credit Facilities||"else if
[Account Code]="12358"then"04. BS - Investment fund size|02. Secured / Unsecured Credit Facilities||"else if
[Account Code]="12360"then"04. BS - Investment fund size|02. Secured / Unsecured Credit Facilities||"else if
[Account Code]="12361"then"04. BS - Investment fund size|02. Secured / Unsecured Credit Facilities||"else if
[Account Code]="12362"then"04. BS - Investment fund size|01. Low Risk Assets||"else if
[Account Code]="12365"then"04. BS - Investment fund size|02. Secured / Unsecured Credit Facilities||"else if
[Account Code]="12400"then"04. BS - Investment fund size|03. Deposits (MYR)||"else if
[Account Code]="12410"then"05. BS - Investment Assets - MAS|||"else if
[Account Code]="12420"then"04. BS - Investment fund size|08. Unit Trusts Schemes||"else if
[Account Code]="12471"then"04. BS - Investment fund size|04. Deposits (Foreign)||"else if
[Account Code]="12472"then"04. BS - Investment fund size|04. Deposits (Foreign)||"else if
[Account Code]="12473"then"04. BS - Investment fund size|04. Deposits (Foreign)||"else if
[Account Code]="12474"then"04. BS - Investment fund size|04. Deposits (Foreign)||"else if
[Account Code]="12475"then"04. BS - Investment fund size|04. Deposits (Foreign)||"else if
[Account Code]="12476"then"04. BS - Investment fund size|04. Deposits (Foreign)||"else if
[Account Code]="12477"then"04. BS - Investment fund size|04. Deposits (Foreign)||"else if
[Account Code]="12478"then"04. BS - Investment fund size|04. Deposits (Foreign)||"else if
[Account Code]="12479"then"04. BS - Investment fund size|04. Deposits (Foreign)||"else if
[Account Code]="12500"then"04. BS - Investment Others|||"else if
[Account Code]="12502"then"06. BS - Investment Account - Provision for Impairment|||"else if
[Account Code]="12504"then"06. BS - Investment Account - Provision for Impairment|||"else if
[Account Code]="12505"then"06. BS - Investment Account - Provision for Impairment|||"else if
[Account Code]="12506"then"06. BS - Investment Account - Provision for Impairment|||"else if
[Account Code]="12510"then"06. BS - Investment Account - Accumulated|||"else if
[Account Code]="12520"then"06. BS - Investment Account - Accumulated|||"else if
[Account Code]="12530"then"BS - Forex unrealised movement|||"else if
[Account Code]="12540"then"04. BS - Investment (Labuan Re Valuation and Unrealised forex)|||"else if
[Account Code]="12551"then"06. BS - Investment Account - Accumulated|||"else if
[Account Code]="12552"then"06. BS - Investment Account - Accumulated|||"else if
[Account Code]="12553"then"06. BS - Investment Account - Accumulated|||"else if
[Account Code]="12554"then"06. BS - Investment Account - Accumulated|||"else if
[Account Code]="12555"then"06. BS - Investment Account - Accumulated|||"else if
[Account Code]="12556"then"06. BS - Investment Account - Accumulated|||"else if
[Account Code]="12557"then"06. BS - Investment Account - Accumulated|||"else if
[Account Code]="12560"then"06. BS - Investment Account - Provision for Impairment|||"else if
[Account Code]="12561"then"06. BS - Investment Account - Provision for Impairment|||"else if
[Account Code]="12562"then"06. BS - Investment Account - Accumulated|||"else if
[Account Code]="12565"then"06. BS - Investment Account - Accumulated|||"else if
[Account Code]="12571"then"06. BS - Investment Account - Accumulated|||"else if
[Account Code]="12610"then"04. BS - Investment fund size|06. Unquoted||"else if
[Account Code]="12611"then"04. BS - Investment fund size|06. Unquoted||"else if
[Account Code]="12612"then"04. BS - Investment fund size|06. Unquoted||"else if
[Account Code]="12614"then"04. BS - Investment fund size|06. Unquoted||"else if
[Account Code]="12615"then"04. BS - Investment fund size|06. Unquoted||"else if
[Account Code]="12616"then"04. BS - Investment Others|||"else if
[Account Code]="12617"then"04. BS - Investment Others|||"else if
[Account Code]="12618"then"04. BS - Investment Others|||"else if
[Account Code]="12619"then"04. BS - Investment Others|||"else if
[Account Code]="12620"then"04. BS - Investment Others|||"else if
[Account Code]="12651"then"06. BS - Investment Account - Accumulated|||"else if
[Account Code]="12652"then"06. BS - Investment Account - Accumulated|||"else if
[Account Code]="12653"then"06. BS - Investment Account - Accumulated|||"else if
[Account Code]="12654"then"06. BS - Investment Account - Accumulated|||"else if
[Account Code]="12655"then"06. BS - Investment Account - Accumulated|||"else if
[Account Code]="12656"then"06. BS - Investment Account - Accumulated|||"else if
[Account Code]="12657"then"06. BS - Investment Account - Accumulated|||"else if
[Account Code]="12660"then"06. BS - Investment Account - Accumulated|||"else if
[Account Code]="12661"then"06. BS - Investment Account - Accumulated|||"else if
[Account Code]="12662"then"06. BS - Investment Account - Accumulated|||"else if
[Account Code]="12665"then"06. BS - Investment Account - Accumulated|||"else if
[Account Code]="12671"then"06. BS - Investment Account - Accumulated|||"else if
[Account Code]="12710"then"04. BS - Investment Others|||"else if
[Account Code]="12714"then"04. BS - Investment Others|||"else if
[Account Code]="12715"then"04. BS - Investment Others|||"else if
[Account Code]="12716"then"04. BS - Investment Others|||"else if
[Account Code]="12724"then"04. BS - Investment Others|||"else if
[Account Code]="12810"then"07. BS - Investment Account - Fair Value & AFS Reserves|||"else if
[Account Code]="12820"then"07. BS - Investment Account - FVTPL Fair Value|||"else if
[Account Code]="12821"then"07. BS - Investment Account - FVTPL Fair Value|||"else if
[Account Code]="12830"then"04. BS - Investment (Labuan Re Valuation and Unrealised forex)|||"else if
[Account Code]="12840"then"06. BS - Investment Account - FVOCI Fair Value|||"else if
[Account Code]="12850"then"06. BS - Investment Account - FVOCI Fair Value|||"else if
[Account Code]="12860"then"06. BS - Investment Account - FVOCI Fair Value|||"else if
[Account Code]="12951"then"06. BS - Investment Account - FVOCI Fair Value|||"else if
[Account Code]="12952"then"06. BS - Investment Account - FVOCI Fair Value|||"else if
[Account Code]="12953"then"06. BS - Investment Account - FVOCI Fair Value|||"else if
[Account Code]="12954"then"06. BS - Investment Account - FVOCI Fair Value|||"else if
[Account Code]="12955"then"06. BS - Investment Account - FVOCI Fair Value|||"else if
[Account Code]="12956"then"06. BS - Investment Account - FVOCI Fair Value|||"else if
[Account Code]="12957"then"06. BS - Investment Account - FVOCI Fair Value|||"else if
[Account Code]="12958"then"06. BS - Investment Account - FVOCI Fair Value|||"else if
[Account Code]="12962"then"07. BS - Investment Account - FVTPL Fair Value|||"else if
[Account Code]="12965"then"07. BS - Investment Account - FVTPL Fair Value|||"else if
[Account Code]="12966"then"07. BS - Investment Account - FVTPL Fair Value|||"else if
[Account Code]="12967"then"07. BS - Investment Account - FVTPL Fair Value|||"else if
[Account Code]="13100"then"02. BS - Fixed Asset - Cost WIP|||"else if
[Account Code]="13200"then"02. BS - Fixed Asset - Cost WIP|||"else if
[Account Code]="13210"then"02. BS - Fixed Asset - Cost WIP|||"else if
[Account Code]="13300"then"02. BS - Fixed Asset - Cost WIP|||"else if
[Account Code]="13400"then"02. BS - Fixed Asset - Cost WIP|||"else if
[Account Code]="13550"then"02. BS - Fixed Asset - Cost WIP|||"else if
[Account Code]="13555"then"02. BS - Fixed Asset - Cost WIP|||"else if
[Account Code]="13560"then"02. BS - Fixed Asset - Cost WIP|||"else if
[Account Code]>="18010"and[Account Code]<="18093"then"BS - Bank|||"else if
[Account Code]="18500"then"BS - Petty Cash|||"else if
[Account Code]="18550"then"BS - MAS - RECEIVEABLE|||"else if
[Account Code]="18600"then"BS - Interfund|||"else if
[Account Code]="18650"then"BS - Amount Due|||"else if
[Account Code]="18660"then"BS - Interco MRE/MRRD|||"else if
[Account Code]="18670"then"BS - Interco|||"else if
[Account Code]="18700"then"BS - Underwriting|||"else if
[Account Code]="18701"then"BS - MAS - PAYABLE|||"else if
[Account Code]="18720"then"BS - MAS - PAYABLE|||"else if
[Account Code]="18730"then"BS - Underwriting|||"else if
[Account Code]="18750"then"BS - Interco|||"else if
[Account Code]="18800"then"BS - SHARE CAPITAL|||"else if
[Account Code]="18900"then"BS - SHARE CAPITAL|||"else if
[Account Code]="19000"then"BS - MAS - RECEIVEABLE|||"else if
[Account Code]="19020"then"BS - MAS - PAYABLE|||"else if
[Account Code]="19050"then"BS - Creditors - Staff LOAN|||"else if
[Account Code]="19060"then"BS - MAS - RECEIVEABLE|||"else if
[Account Code]="19070"then"BS - Creditors - Staff LOAN|||"else if
[Account Code]="19080"then"BS - MAS - RECEIVEABLE|||"else if
[Account Code]="19085"then"BS - MAS - RECEIVEABLE|||"else if
[Account Code]="19301"then"08. BS - Investment Account - Dividend Receivable|||"else if
[Account Code]="19302"then"08. BS - Investment Account - Dividend Receivable|||"else if
[Account Code]>="19350"and[Account Code]<="19379"then"09. BS - Investment Account - Interest Receivable|||"else if
[Account Code]="19650"then"BS - Underwriting|||"else if
[Account Code]="19651"then"BS - Underwriting|||"else if
[Account Code]="19652"then"UW - BS - REINSTATEMENT PREMIUM|||"else if
[Account Code]="19653"then"UW - BS - PROV FOR LARGE LOSSES|||"else if
[Account Code]="19654"then"UW - BS - PROV OS CLAIMS|||"else if
[Account Code]="19655"then"UW - BS - PROV FOR LARGE LOSSES|||"else if
[Account Code]="19656"then"UW - BS - PROV OS CLAIMS|||"else if
[Account Code]="19657"then"UW - BS - IBNR|||"else if
[Account Code]="19658"then"UW - BS|||"else if
[Account Code]="19659"then"UW - BS - PRAD|||"else if
[Account Code]="19670"then"UW - BS - UPR|||"else if
[Account Code]="19671"then"UW - BS - UPR|||"else if
[Account Code]="19672"then"BS - Underwriting|||"else if
[Account Code]="19700"then"BS - Underwriting|||"else if
[Account Code]="19710"then"BS - Underwriting Deposit|||"else if
[Account Code]="19711"then"BS - Underwriting Deposit|||"else if
[Account Code]="19800"then"BS - Amount Due|||"else if
[Account Code]="19810"then"BS - Amount Due|||"else if
[Account Code]="19811"then"BS - Amount Due|||"else if
[Account Code]="19812"then"BS - Amount Due - other|||"else if
[Account Code]="19813"then"BS - Amount Due|||"else if
[Account Code]="19814"then"BS - Interco|||"else if
[Account Code]="19815"then"BS - Interco|||"else if
[Account Code]="19816"then"BS - Interco|||"else if
[Account Code]="19817"then"BS - Interco|||"else if
[Account Code]="19818"then"BS - Interco|||"else if
[Account Code]="19820"then"BS - MAS - SALARY RELATED PAYABLE|||"else if
[Account Code]="19821"then"BS - Interco|||"else if
[Account Code]="20110"then"UW - BS - PROV OS CLAIMS|||"else if
[Account Code]="20111"then"UW - BS - PROV OS CLAIMS|||"else if
[Account Code]="20112"then"UW - BS - IBNR|||"else if
[Account Code]="20113"then"UW - BS - PROV FOR LARGE LOSSES|||"else if
[Account Code]="20114"then"UW - BS - PRAD|||"else if
[Account Code]="20131"then"BS - Underwriting|||"else if
[Account Code]="20140"then"UW - BS - UPR|||"else if
[Account Code]="20141"then"UW - BS - UPR|||"else if
[Account Code]="20151"then"BS - TAX|||"else if
[Account Code]="20152"then"BS - TAX|||"else if
[Account Code]="20153"then"BS - TAX|||"else if
[Account Code]="20154"then"BS - TAX|||"else if
[Account Code]="20155"then"BS - Underwriting|||"else if
[Account Code]>="20160"and[Account Code]<="20190"then"BS - GST Provision Account|||"else if
[Account Code]="20191"then"BS - SST PAYABLE|||"else if
[Account Code]="20300"then"BS - Underwriting|||"else if
[Account Code]="20310"then"BS - Underwriting|||"else if
[Account Code]="20320"then"BS - Underwriting|||"else if
[Account Code]="20330"then"BS - Underwriting|||"else if
[Account Code]="20400"then"BS - UW - Provision for Impairment Insurance Receivables|||"else if
[Account Code]="20401"then"BS - UW - Provision for Impairment Insurance Receivables|||"else if
[Account Code]="20410"then"BS - SHARE CAPITAL|||"else if
[Account Code]="20450"then"BS - UW - Provision for Impairment Insurance Receivables|||"else if
[Account Code]="20500"then"BS - Underwriting|||"else if
[Account Code]="20600"then"BS - Underwriting|||"else if
[Account Code]="20700"then"BS - Amount Due|||"else if
[Account Code]="21001"then"BS - Monthly Provision - ME|||"else if
[Account Code]="21002"then"BS - Monthly Provision - ME|||"else if
[Account Code]="21003"then"BS - KIV|||"else if
[Account Code]="21004"then"BS - Monthly Provision - ME|||"else if
[Account Code]="21005"then"BS - MAS - PAYABLE|||"else if
[Account Code]="21006"then"BS - I&E - Properties|||"else if
[Account Code]="21007"then"BS - MAS - PAYABLE|||"else if
[Account Code]="21008"then"BS - Monthly Provision - ME|||"else if
[Account Code]="21009"then"BS - MAS - PAYABLE|||"else if
[Account Code]="21100"then"BS - MAS - PAYABLE|||"else if
[Account Code]="22003"then"BS - MAS - PAYABLE|||"else if
[Account Code]="22005"then"BS - MAS - SALARY RELATED PAYABLE|||"else if
[Account Code]="22006"then"BS - MAS - PAYABLE|||"else if
[Account Code]="22007"then"BS - MAS - PAYABLE|||"else if
[Account Code]="22009"then"BS - MAS - PAYABLE|||"else if
[Account Code]="22010"then"BS - MAS - SALARY RELATED PAYABLE|||"else if
[Account Code]="22012"then"BS - MAS - SALARY RELATED PAYABLE|||"else if
[Account Code]="22017"then"BS - MAS - SALARY RELATED PAYABLE|||"else if
[Account Code]="22018"then"BS - Monthly Provision - ME|||"else if
[Account Code]="22019"then"BS - Monthly Provision - ME|||"else if
[Account Code]="22020"then"BS - MAS - SALARY RELATED PAYABLE|||"else if
[Account Code]="22151"then"BS - MAS - PAYABLE|||"else if
[Account Code]="22155"then"BS - MAS - PAYABLE|||"else if
[Account Code]="23000"then"04. BS - Investment Others|||"else if
[Account Code]="24000"then"BS - MAS - PAYABLE|||"else if
[Account Code]="25101"then"BS - LOAN|||"else if
[Account Code]="25106"then"BS - LOAN|||"else if
[Account Code]="25107"then"BS - LOAN|||"else if
[Account Code]="25110"then"BS - LOAN INTREST PAYABLE|||"else if
[Account Code]="25112"then"BS - LOAN INTREST PAYABLE|||"else if
[Account Code]="26001"then"BS - MAS - PAYABLE - Other Debt/Cred|||"else if
[Account Code]="26002"then"BS - MAS - PAYABLE - Other Debt/Cred|||"else if
[Account Code]="30011"then"PL - UW - GP|||"else if
[Account Code]="30012"then"PL - UW - GP|||"else if
[Account Code]="30013"then"PL - UW - GP|||"else if
[Account Code]="30014"then"PL - UW - GP|||"else if
[Account Code]="30050"then"PL - UW|||"else if
[Account Code]="30100"then"PL - UW|||"else if
[Account Code]="30201"then"PL - UW - CLAIMS PAID|||"else if
[Account Code]="30202"then"PL - UW - CLAIMS PAID|||"else if
[Account Code]="30203"then"PL - UW - CLAIMS PAID|||"else if
[Account Code]="30204"then"PL - UW - CLAIMS PAID|||"else if
[Account Code]="30205"then"PL - UW - CLAIMS PAID|||"else if
[Account Code]="30210"then"PL - UW|||"else if
[Account Code]="30301"then"PL - UW|||"else if
[Account Code]="30302"then"PL - UW|||"else if
[Account Code]="30303"then"PL - UW|||"else if
[Account Code]="30304"then"PL - UW|||"else if
[Account Code]="30351"then"PL - UW|||"else if
[Account Code]="30352"then"PL - UW|||"else if
[Account Code]="30401"then"PL - UW - COMMISSION|||"else if
[Account Code]="30402"then"PL - UW - PROFIT COMM|||"else if
[Account Code]="30410"then"PL|||"else if
[Account Code]="30497"then"PL - UW - WAKALAH INCOME|||"else if
[Account Code]="30498"then"PL - UW - WAKALAH INCOME|||"else if
[Account Code]="30499"then"PL - UW - WAKALAH INCOME|||"else if
[Account Code]="30500"then"PL - UW - WAKALAH INCOME|||"else if
[Account Code]="30602"then"PL|||"else if
[Account Code]>="32010"and[Account Code]<="32279"then"PL - INV INC|||"else if
[Account Code]="32501"then"PL|||"else if
[Account Code]="32506"then"PL - Other Income|||"else if
[Account Code]="32810"then"PL - INV INC|||"else if
[Account Code]="32820"then"PL - INV INC|||"else if
[Account Code]="32821"then"PL - INV INC|||"else if
[Account Code]="32822"then"PL - INV INC|||"else if
[Account Code]="32830"then"PL|||"else if
[Account Code]="32862"then"PL - INV INC|||"else if
[Account Code]="32865"then"PL - INV INC|||"else if
[Account Code]="32866"then"PL - INV INC|||"else if
[Account Code]="32867"then"PL - INV INC|||"else if
[Account Code]="34002"then"PL - Other Income|||"else if
[Account Code]="34003"then"PL - Other Income|||"else if
[Account Code]="37600"then"PL - INV INC|||"else if
[Account Code]="37601"then"PL - INV INC|||"else if
[Account Code]="37602"then"PL - INV INC|||"else if
[Account Code]="37603"then"PL - INV INC|||"else if
[Account Code]="37604"then"PL - INV INC|||"else if
[Account Code]="37650"then"PL - INV INC|||"else if
[Account Code]="37651"then"PL - INV INC|||"else if
[Account Code]="37652"then"PL - INV INC|||"else if
[Account Code]="37653"then"PL - INV INC|||"else if
[Account Code]="37654"then"PL - INV INC|||"else if
[Account Code]="37655"then"PL - INV INC|||"else if
[Account Code]="37656"then"PL - INV INC|||"else if
[Account Code]="37657"then"PL - INV INC|||"else if
[Account Code]="37658"then"PL - INV INC|||"else if
[Account Code]="37660"then"PL - INV INC|||"else if
[Account Code]="37661"then"PL - INV INC|||"else if
[Account Code]="37662"then"PL - INV INC|||"else if
[Account Code]="37665"then"PL - INV INC|||"else if
[Account Code]="37671"then"PL - INV INC|||"else if
[Account Code]="37712"then"PL - SND|||"else if
[Account Code]="37713"then"PL - SND|||"else if
[Account Code]="37714"then"PL - SND|||"else if
[Account Code]="37715"then"PL - SND|||"else if
[Account Code]="37810"then"PL|||"else if
[Account Code]="37811"then"PL|||"else if
[Account Code]="37812"then"PL|||"else if
[Account Code]="37813"then"PL - Other Income|||"else if
[Account Code]="37814"then"PL - Other Income|||"else if
[Account Code]="37815"then"PL - Other Income|||"else if
[Account Code]="37816"then"PL - Other Income|||"else if
[Account Code]="37817"then"PL - Other Income|||"else if
[Account Code]="37818"then"PL - Other Income|||"else if
[Account Code]="37819"then"PL|||"else if
[Account Code]="37820"then"PL - Other Income|||"else if
[Account Code]="37823"then"PL - Other Income|||"else if
[Account Code]="37825"then"PL - GSSU|||"else if
[Account Code]="37826"then"PL - IN - INTERCO|||"else if
[Account Code]="37827"then"PL - IN - INTERCO|||"else if
[Account Code]="37828"then"PL - MGMT FEES|||"else if
[Account Code]="37830"then"PL|||"else if
[Account Code]="37832"then"PL|||"else if
[Account Code]="37835"then"PL|||"else if
[Account Code]="37840"then"PL - Other Income|||"else if
[Account Code]="39101"then"PL - Other Income|||"else if
[Account Code]="39502"then"PL|||"else if
[Account Code]="39605"then"PL - Other Income|||"else if
[Account Code]="40010"then"PL - UW - REINSURANCE|||"else if
[Account Code]="40011"then"PL - UW - REINSURANCE|||"else if
[Account Code]="40012"then"PL - UW - REINSURANCE|||"else if
[Account Code]="40013"then"PL - UW - REINSURANCE|||"else if
[Account Code]="40100"then"PL - UW - REINSURANCE|||"else if
[Account Code]="40101"then"PL - UW - REINSURANCE|||"else if
[Account Code]="40102"then"PL - UW - REINSURANCE|||"else if
[Account Code]="40103"then"PL - UW - REINSURANCE|||"else if
[Account Code]="40201"then"PL - UW - CLAIMS PAID|||"else if
[Account Code]="40202"then"PL - UW - CLAIMS PAID|||"else if
[Account Code]="40203"then"PL - UW - CLAIMS PAID|||"else if
[Account Code]="40204"then"PL|||"else if
[Account Code]="40205"then"PL|||"else if
[Account Code]="40300"then"PL - UW|||"else if
[Account Code]="40301"then"PL - UW|||"else if
[Account Code]="40302"then"PL - UW|||"else if
[Account Code]="40303"then"PL - UW|||"else if
[Account Code]="40304"then"PL - UW|||"else if
[Account Code]="40305"then"PL - UW - WAKALAH INCOME|||"else if
[Account Code]="40306"then"PL|||"else if
[Account Code]="40351"then"PL - UW|||"else if
[Account Code]="40352"then"PL - UW|||"else if
[Account Code]="40401"then"PL - UW - COMMISSION|||"else if
[Account Code]="40402"then"PL - UW - PROFIT COMM|||"else if
[Account Code]="40403"then"PL - UW|||"else if
[Account Code]="40410"then"PL|||"else if
[Account Code]="40501"then"PL|||"else if
[Account Code]="40502"then"PL - UW - EXPENSES|||"else if
[Account Code]="40503"then"PL - UW - EXPENSES|||"else if
[Account Code]="40504"then"PL - Forex Gain/Loss|||"else if
[Account Code]="40505"then"PL|||"else if
[Account Code]="40507"then"PL|||"else if
[Account Code]="40508"then"PL|||"else if
[Account Code]="40509"then"PL|||"else if
[Account Code]="40511"then"PL - UW - EXPENSES|||"else if
[Account Code]="40515"then"PL - UW|||"else if
[Account Code]="40516"then"PL - UW|||"else if
[Account Code]="40600"then"PL - UW - EXPENSES|||"else if
[Account Code]="40700"then"PL - UW|||"else if
[Account Code]="40701"then"PL - UW|||"else if
[Account Code]="40702"then"PL|||"else if
[Account Code]="40797"then"PL - UW - WAKALAH FEES|||"else if
[Account Code]="40798"then"PL - UW - WAKALAH FEES|||"else if
[Account Code]="40799"then"PL - UW - WAKALAH FEES|||"else if
[Account Code]="40800"then"PL - UW - WAKALAH FEES|||"else if
[Account Code]="40801"then"PL|||"else if
[Account Code]="40803"then"PL - Forex Gain/Loss|||"else if
[Account Code]="40804"then"PL - Forex Gain/Loss|||"else if
[Account Code]="40805"then"PL - Forex Gain/Loss|||"else if
[Account Code]="40806"then"PL - Forex Gain/Loss|||"else if
[Account Code]="40807"then"PL - Forex Gain/Loss|||"else if
[Account Code]="40808"then"PL - Forex Gain/Loss|||"else if
[Account Code]="40809"then"PL - Forex Gain/Loss|||"else if
[Account Code]="40810"then"PL - Forex Gain/Loss|||"else if
[Account Code]="40811"then"PL - Forex Gain/Loss|||"else if
[Account Code]="41000"then"PL|||"else if
[Account Code]="41001"then"PL - M.E - IVS|||"else if
[Account Code]="41002"then"PL - M.E - IVS|||"else if
[Account Code]="41003"then"PL - M.E - IVS|||"else if
[Account Code]="41004"then"PL - INV INC|||"else if
[Account Code]="41005"then"PL - M.E - IVS|||"else if
[Account Code]="41007"then"PL - UW - WAKALAH INCOME|||"else if
[Account Code]="41010"then"PL - M.E|||"else if
[Account Code]="41011"then"PL - M.E|||"else if
[Account Code]="41012"then"PL|||"else if
[Account Code]="41013"then"PL - M.E - IVS|||"else if
[Account Code]="41015"then"PL - M.E - IVS|||"else if
[Account Code]="41051"then"PL - INV INC|||"else if
[Account Code]="41052"then"PL - INV INC|||"else if
[Account Code]="41053"then"PL - INV INC|||"else if
[Account Code]="41054"then"PL - INV INC|||"else if
[Account Code]="41055"then"PL - INV INC|||"else if
[Account Code]="41056"then"PL - INV INC|||"else if
[Account Code]="41057"then"PL - INV INC|||"else if
[Account Code]="41058"then"PL - INV INC|||"else if
[Account Code]="41060"then"PL - INV INC|||"else if
[Account Code]="41061"then"PL - INV INC|||"else if
[Account Code]="41062"then"PL - INV INC|||"else if
[Account Code]="41065"then"PL - INV INC|||"else if
[Account Code]="41071"then"PL - INV INC|||"else if
[Account Code]="41501"then"PL - M.E|||"else if
[Account Code]="41502"then"PL - M.E|||"else if
[Account Code]="41503"then"PL - M.E|||"else if
[Account Code]="41504"then"PL - M.E|||"else if
[Account Code]="41505"then"PL - M.E|||"else if
[Account Code]="41506"then"PL - M.E|||"else if
[Account Code]="41810"then"PL - INV INC|||"else if
[Account Code]="41820"then"PL - INV INC|||"else if
[Account Code]="41860"then"PL - INV INC|||"else if
[Account Code]="41861"then"PL - INV INC|||"else if
[Account Code]>="42001"and[Account Code]<="45508"then"PL - M.E|||"else if
[Account Code]="45509"then"PL - GST|||"else if
[Account Code]="45510"then"PL - M.E|||"else if
[Account Code]="45511"then"PL - UW|||"else if
[Account Code]="46001"then"PL - M.E|||"else if
[Account Code]="46501"then"PL - M.E|||"else if
[Account Code]="46502"then"PL - M.E|||"else if
[Account Code]="46503"then"PL - M.E|||"else if
[Account Code]="47501"then"PL - M.E|||"else if
[Account Code]="47712"then"PL - SND|||"else if
[Account Code]="47714"then"PL - SND|||"else if
[Account Code]="47715"then"PL - SND|||"else if
[Account Code]="47830"then"PL|||"else if
[Account Code]="48501"then"PL - M.E|||"else if
[Account Code]="48502"then"PL - M.E|||"else if
[Account Code]="48503"then"PL - M.E|||"else if
[Account Code]="48504"then"PL - M.E|||"else if
[Account Code]="48505"then"PL - M.E|||"else if
[Account Code]="48506"then"PL|||"else if
[Account Code]="48508"then"PL - M.E|||"else if
[Account Code]="48509"then"PL - M.E|||"else if
[Account Code]="48510"then"PL - M.E|||"else if
[Account Code]="48512"then"|||"else if
[Account Code]="48601"then"PL|||"else if
[Account Code]="48602"then"PL|||"else if
[Account Code]="48603"then"PL|||"else if
[Account Code]="48604"then"PL - I&E - Properties|||"else if
[Account Code]="48605"then"PL|||"else if
[Account Code]="48606"then"PL|||"else if
[Account Code]="48705"then"PL - M.E|||"else if
[Account Code]>="49101"and[Account Code]<="49601"then"PL - M.E|||"else if
[Account Code]="49602"then"PL - M.E - OTHERS|||"else if
[Account Code]="49603"then"PL - M.E|||"else if
[Account Code]="49604"then"PL - Forex Gain/Loss|||"else if
[Account Code]="49605"then"PL - M.E|||"else if
[Account Code]="49606"then"PL - M.E|||"else if
[Account Code]="49608"then"PL - TAX|||"else if
[Account Code]="49609"then"PL - TAX|||"else if
[Account Code]="49610"then"PL - Finance Cost|||"else if
[Account Code]="49611"then"PL - Finance Cost|||"else if
[Account Code]="49613"then"|||"else if
[Account Code]="49614"then"PL - M.E|||"else if
[Account Code]="49615"then"PL - TAX|||"else if
[Account Code]="49616"then"PL - M.E|||"else if
[Account Code]="49700"then"PL|||"else if
[Account Code]="49710"then"PL|||"else if
[Account Code]="50005"then"BS - UW CLIENT - OTHERS|||"else if
[Account Code]="50006"then"BS - UW CLIENT - OTHERS|||"else if
[Account Code]="55001"then"BS - Underwriting Control Account|||"else if
[Account Code]="60005"then"BS - MAS - PAYABLE - Other Debt/Cred|||"else if
[Account Code]>="61001"and[Account Code]<="61200"then"BS - DEBTOR LSR TSD - Acc 61001 to 61200|||"else if
[Account Code]>="65010"and[Account Code]<="65030"then"08. BS - Investment Account - Broker|||"else if
[Account Code]="65700"then"08. BS - Investment Account - Control Account|||"else if
[Account Code]>="66001"and[Account Code]<="66118"then"BS - Debtors Properties|||"else if
[Account Code]="7E004"then"11. BS - Creditors - Supplier - Acc 7A001 to 7Z999|||"else if
[Account Code]="70004"then"BS - MAS - PAYABLE - Other Debt/Cred|||"else if
[Account Code]="70005"then"BS - MAS - PAYABLE - Other Debt/Cred|||"else if
[Account Code]="70006"then"BS - MAS - PAYABLE|||"else if
[Account Code]="70008"then"BS - MAS - PAYABLE|||"else if
[Account Code]="70009"then"BS - MAS - PAYABLE|||"else if
[Account Code]="70010"then"BS - MAS - PAYABLE|||"else if
[Account Code]="70011"then"BS - MAS - SALARY RELATED PAYABLE|||"else if
[Account Code]="70055"then"BS - MAS - PAYABLE|||"else if
[Account Code]="70057"then"BS - MAS - PAYABLE|||"else if
[Account Code]>="70701"and[Account Code]<="71007"then"BS - MAS - SALARY RELATED PAYABLE|||"else if
[Account Code]="71021"then"BS - MAS - PAYABLE|||"else if
[Account Code]="71101"then"BS - MAS - PAYABLE|||"else if
[Account Code]="71106"then"BS - MAS - PAYABLE|||"else if
[Account Code]="71402"then"BS - MAS - PAYABLE|||"else if
[Account Code]="73012"then"BS - MAS - PAYABLE|||"else if
[Account Code]="74001"then"BS - KIV|||"else if
[Account Code]="85010"then"BS - SHARE CAPITAL|||"else if
[Account Code]="85020"then"BS - SHARE CAPITAL|||"else if
[Account Code]="85021"then"BS - MAS - PAYABLE|||"else if
[Account Code]="85030"then"BS - SHARE CAPITAL|||"else if
[Account Code]="85040"then"BS - SHARE CAPITAL|||"else if
[Account Code]="85050"then"07. BS - Investment Account - Fair Value & AFS Reserves|||"else if
[Account Code]="85055"then"BS - TAX|||"else if
[Account Code]="85060"then"06. BS - Investment Account - FVOCI Reserves|||"else if
[Account Code]="85061"then"06. BS - Investment Account - FVOCI Reserves|||"else if
[Account Code]="85062"then"06. BS - Investment Account - FVOCI Reserves|||"else if
[Account Code]="85063"then"06. BS - Investment Account - FVOCI Reserves|||"else if
[Account Code]="85064"then"06. BS - Investment Account - FVOCI Reserves|||"else if
[Account Code]="85065"then"BS - TAX|||"else if
[Account Code]="85066"then"06. BS - Investment Account - FVOCI Reserves|||"else if
[Account Code]="85067"then"06. BS - Investment Account - FVOCI Reserves|||"else if
[Account Code]="85068"then"06. BS - Investment Account - FVOCI Reserves|||"else if
[Account Code]="85069"then"BS - UW CLIENT - CREDIT CONTROL - Acc 50Axx to 50Zxx|||"else if
[Account Code]="85070"then"06. BS - Investment Account - FVOCI Reserves|||"else if
[Account Code]="85075"then"BS - TAX|||"else if
[Account Code]="85082"then"07. BS - Investment Account - FVTPL Reserves|||"else if
[Account Code]="85085"then"07. BS - Investment Account - FVTPL Reserves|||"else if
[Account Code]="85086"then"07. BS - Investment Account - FVTPL Reserves|||"else if
[Account Code]="85087"then"07. BS - Investment Account - FVTPL Reserves|||"else if
[Account Code]="99999"then"BS - MAS - PAYABLE|||"else if
[Account Code]>="501II"and[Account Code]<="50ZZZ"then"BS - UW CLIENT - CREDIT CONTROL - Acc 50Axx to 50Zxx|||"else if
[Account Code]="551II"then"BS - UW CLIENT|||"else if
[Account Code]>="55A52"and[Account Code]<="55ZZZ"then"BS - UW CLIENT - RESERVE - Acc 55Axx to 55Zxx|||"else if
[Account Code]="60CAB"then"BS - Amount Due - other|||"else if
[Account Code]="60CCM"then"BS - Amount Due - other|||"else if
[Account Code]="60HLD"then"BS - Interco|||"else if
[Account Code]="60ILH"then"BS - Amount Due - other|||"else if
[Account Code]="60LAB"then"BS - Amount Due - other|||"else if
[Account Code]="60MBB"then"BS - Amount Due - other|||"else if
[Account Code]="60MID"then"BS - Amount Due - other|||"else if
[Account Code]="60MIP"then"BS - Amount Due - other|||"else if
[Account Code]="60MRC"then"BS - Amount Due - other|||"else if
[Account Code]="60MRD"then"BS - Interco|||"else if
[Account Code]="60MRDC"then"BS - Interco|||"else if
[Account Code]="60MRE"then"BS - Interco|||"else if
[Account Code]="60MRT"then"BS - Interco|||"else if
[Account Code]="60MSB"then"BS - Interco|||"else if
[Account Code]="60MTD"then"BS - Amount Due - other|||"else if
[Account Code]="60PIA"then"BS - Amount Due - other|||"else if
[Account Code]="60PNB"then"BS - Amount Due - other|||"else if
[Account Code]="60RMC"then"BS - MAS - RECEIVEABLE|||"else if
[Account Code]="60SCS"then"BS - Amount Due - other|||"else if
[Account Code]="60SHM"then"BS - Amount Due - other|||"else if
[Account Code]="60SSB"then"BS - Interco|||"else if
[Account Code]="60TFA"then"BS - Amount Due - other|||"else if
[Account Code]="60TIB"then"BS - Interco|||"else if
[Account Code]="60TIG"then"BS - Interco|||"else if
[Account Code]="621II"then"BS - UW CLIENT|||"else if
[Account Code]>="62A52"and[Account Code]<="62ZZZ"then"BS - UW CLIENT - Acc 62Axx to 62Zxx|||"else if
[Account Code]="70005D"then"BS - MAS - PAYABLE - Other Debt/Cred|||"else if
[Account Code]>="72AD1"and[Account Code]<="72LW5"then"BS - UW CLIENT - Acc 72Axx to 72Zxx|||"else if
[Account Code]>="73A01"and[Account Code]<="73Z99then"10. BS - Creditors - Staff - Acc 73A01 TO 73Z99|||"else if
[Account Code]>="7A001"and[Account Code]<="7Z999"then"11. BS - Creditors - Supplier - Acc 7A001 to 7Z999|||"else if
[Account Code]="99999Z"then"|||"else if
[Account Code]>="R1010"and[Account Code]<="7Z999"then"PL - M.E|||"else if
"to check"

<colgroup><col></colgroup><tbody>
</tbody>
 

Matt Allington

MrExcel MVP
Joined
Dec 18, 2014
Messages
1,189
There is no doubt in my mind that there is a better way to do what you want to do. What are you trying to achieve?
 

aam1932

Board Regular
Joined
Jun 2, 2010
Messages
175
thank for your consent,

actually this all my account code (general ledger), for reporting purposes, any to grouping the account code as per requirement. Example account code 10100 to 10500 should group under Fixed Asset. i also have situation that if that account negative figure should under different group and positive different group.

Hope you understand what i want to do

thank you
 

Matt Allington

MrExcel MVP
Joined
Dec 18, 2014
Messages
1,189
If you are trying to build a P&L, you should use a different approach. You need a chart of accounts that has all the account codes in a column, then extra columns for the roll ups. You also ideally would have a header table to help with the sign of the value (negative or positive). Take a look at this video showing how it is done using Power Pivot.


https://www.youtube.com/watch?v=ojHZkWkEY7Q/
 

Forum statistics

Threads
1,085,316
Messages
5,382,928
Members
401,809
Latest member
jbeanx80

Some videos you may like

This Week's Hot Topics

Top