IN EXCEL To format excel number in lakh(L) and thousand(K) only -: [<100000] 0.000,_)"K";#\.00,_)"L" To format excel number in lakh(L) and Crore(Cr) only -: [<10000000] #\.00,_)"L";#\.0000,_)"Cr" Video link --: https://youtu.be/sTtXI6r-f4A IN GOOGLE SHEET To write number according to Indian place value system [$₹][>9999999]##\,##\,##\,##0.00;[$₹][>99999]##\,##\,##0.00;[$₹]##,##0.00
Uttar Pradesh House Tax Calculation-: House Tax is calculated on Carpet area Carpet area = Covered area - 20% of Covered area Covered area is written on नक्शा given by MDA For Residential-: eg-: House Super area = 2200 sqft Note-: There is 20% difference between super area & covered area so, covered area = 2200 - 20% of 2200 covered area = 1760 sqft ~1800 sqft ( approx.) Note-: Carpet area is 20% less than Covered area so, Carpet area = 1800 - 20% of 1800 Carpet area = 1440 sqft Case 1: If you are living in that house, then 25% की छूट 27,000 - 25% of 27,000 =20,250 House tax of 1 year = 15% of 20,250 = 3038 Rs per year Case 2: If house is given on rent then there is no discount of 25% = 27,000 + 25 % of 27,000 = 33,750 House tax of 1 year = 15 % of 33,750 ...
Comments
Post a Comment