Kolkata-Pune-Mumbai
27349 Points
Joined October 2007
Might Be U All Forget to Owner of This Forum, Mr. Dhara, Who's Requirement is Formula For IT Computation in Excel Sheet, Here is Ur Formula. for Individual/Women/Senior Citizen.For Assessment year 2009-10. & u Can Change it According to for Which A.Y. U are in need.
IF(A39="STATUS : GENERAL",IF(AND((M51>150000),(M51<=300001)),(M51*10%-15000),IF(AND((M51>300000),(M51<=500001)),(M51*20%-45000),IF(AND(M51>500000),(M51*30%-95000),0))),IF(A39="Status : WOMEN",(IF(AND((M51>180000),(M51<=300001)),(M51*10%-18000),IF(AND((M51>=300000),(M51<=500001)),(M51*20%-48000),IF(M51>=500001,(M51*30%-98000),0)))),IF(A39="Status : SENIOR CITIZEN",(IF(AND((M51>225000),(M51<=225001)),(M51*10%-22500),IF(AND((M51>=300000),(M51<=500001)),(M51*20%-52500),IF(M51>=500001,(M51*30%-102500),0)))),0)))
Mr. Dhara If UR Geting This Formula Then its OK, Otherwise Let Me Know, I Will Take to U .