Search results

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...

I have an Excel worksheet(say sheet 1)consisting with month wise salary (apr-Mar)and against that month wise P.Tax which is fetching it's data from an another worksheet named as 2011-12. Now I want to create an another similar worksheet(say sheet 2) which will fetch it's data from the worksheet...

Can any body help me to learn pivot table and dash board in simple version since my intelligence level is just average. Thanks & regards aratrika

I have an worksheet (say worksheet A) for calculation of TDS of the employees. I used to process salary in another worksheet(say worksheet B)in separate sheets for every month i.e sheet 1 for Apr , sheet 2 for May and like that. The same row is maintained every month for individual and I want...

Is it possible to mail merge with excel. Could some body help me. Aratrika

i want to create a spreadsheet which shall contain sales related data such as name of the products sold, name of the dealers, number of quantity, amount, days of credit allowed, payment received,outstanding details.goods returned,sales tax form receivable/received etc. is it possible to...

I have few important excel files which I do not want to be accessed by others on LAN. Can I protect these files by using some formula which can not be seen.is there any scope to apply such formula in another file to protect the desired one (e.g. applying formula in X file to protect Y file.

Atanu & VJ Thanks for your input but it is still not understood and it seems I must elaborate a little more. I have a file (say file X.xls.) containing name of the employee with DOB. I have an another file (say Y.xls) where I used to calculate salary every month and accordingly payslips are...

Thanks but not understood how will it work, could you please elaborate a further. aratrika

I am maintaining salary sheet and payslip in excel for all of my employee. Date of birth and marriage dates are maintained in a separate excel file. Now i want the birth day wishes to be printed on the payslip automatically in the respective month by picking up the data from the file where the...

I want the birth day wish to be printed automatically on the payslip of all of my employee in their respective month's payslip.Date of birth is available in an another file. Could any body suggest any solution. aratrika