Search results

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

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

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

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.

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

Hi. I am new new and just registered. it seems that it will be helpful. i have a problem to calculate TDS of the staffs.I use to calculate income tax of the employees in a excel sheet and i want their taxable income to be calculated as prescribed by the authority which is as follows if taxable...