I WANT TO USE THIS CODE DEPENDING THE TYPE OF THE ACCOUNT, THERE ARE 2 TYPES OF ACCOUNT RESIDENTIAL AND COMMERCIAL ACCOUNT.
IF "RESIDENTIAL ACCOUNT" OR (R) ACCOUNT IS TRUE:
THIS CODE WILL RUN
IIf([m3]>=36,((((([m3]-15)-10)-10)*21.56)+472.5),IIf([m3]>=26,(((([m3]-15)-10)*17.25)+300),IIf([m3]>=16,((([m3]-15)*15)+150),IIf([m3]>=15,(150),IIf([m3]>=10,(150),IIf([m3]<=9,[m3]*15,"0"))))))
IF "COMMERCIAL ACCOUNT" OR (C)
IIf([m3]>=36,((((([m3]-15)-10)-10)*43.13)+945),IIf([m3]>=26,(((([m3]-15)-10)*34.5)+600),IIf([m3]>=16,((([m3]-15)*30)+300),IIf([m3]>=15,(300),IIf([m3]>=10,(300),IIf([m3]<=9,[m3]*30,"0"))))))