Recent content by aratrika

Dear all, I am just speechless for the overwhelming response from you guys once again and I don't know how to thank you all. I will take the solution given by NARAYANK991 at the moment since I needn't have to change much in my existing setup and I will definitely look in to the other valued...

I used to calculate staff IT till FY 2012-13 which was a) up to 2 lac =0, b) 2 lac to 5 lac =10% of the amount by which the total exceeds 2 lac, c) 5 lac to 10 lac = 30000+20% of the amount by which the total exceeds 5 lac and above d) 10 lac = 130000 +30% of the amount by which the total...

Thanks shrivallabha. It is working.

I WANT THE CELL VALUE WHATEVER IT MAY BE THE AMOUNT TO BE RESTRICTED TO THE NEAREST 100 RUPEE. PLS. HELP. THANKS & REGARDS ARATRIKA

Kindly help me out that i have a cell value Rs.9957 in A1 and i want to load 5%-5% and to be rounded off to nearest 50 rupee. In this case the value will be Rs. 10481(9957/.95+9957) and i want the value to be rounded to 10500 and if the value is 10449 then rounded off to 10400. pls help me...

can anybody please tell me the easiest way to calculate compound interest in excel. Actually i was compiling an worksheet on monthly PF contribution and interest thereof.It seems that the Interest compounded annually @ 8% P.A.which is credited at the end of each financial year.Hope some body...

Is their any formula which shall convert words to number or number to words. for example July 5, 2012 to 05/07/2012 or Rs. 112265.00 to Rupees One Lac Twelve Thousand Two Hundred Sixty Five.Look forward to am early reply as always. Thanks & regards Aratrika

Suppose one of my branch office sales is Rs. 5583000 per month and salary paid for that particular month is 16984. What will be the formula in excel to find out salary paid against per 1 rupee sales. It's very urgent and i am sure somebody will be generous to post as always. Thanking you in...

Kindly help me to put formula for cumulative total of a column which will continuously keep on adding while row number will increase in number.For example suppose cumulative total of column A1 to A8 now is say 100 but it may go up to A100 or may be A1000 and the formula will keep on adding. I...

Thanks Faseeh it's working. Could you please explain the logic of the formula so that in future i can also use the same where needed. Thanks & regards Aratrika

Sorry SirJB7. Now I think the link have been properly posted. Thanks & regards Aratrika

Dear Faseeh & SirJB7, Sorry i am late.I enclose herewith two links which are self explanatory.Every month i used to process salary in a different worksheet and copy them and save them in Salary Sheet 11-12 and on and on. Some more related files are created which are fetching their data from...

Hi Faseeh, My problem is little different. Let me explain as under. 1. I have an excel file named "P.Tax Annual" which is consisting with sheets per year such as 2011-12. The sheet 2011-12 is consisting with name of the employees and their respective monthly income and monthly P.Tax as...

Hi Faseeh, Thanks for your interest in the matter but could you please elaborate the same in step by step method. Look forward to your early response. Thanks & regards Aratrika

Thanks NARAYANAK991 for your valuable feed back but I must inform you that the worksheet 2011-12 is not just a sheet but consisting with 12 sheet namely apr, may and on like that till march. Sheet 1 is fetching data from all the monthly sheet of 2011-12. Therefore it seems copy of the worksheet...