Q.1 An excel file has eight sheets and each sheet contains total amount in numeric. i want to sum of all eight sheets in a new sheet by using an excel formula.

please let me know the formula by which i can summation grand total.

Q.2 i have seen in a excel formula the symbol '^' is used as a part of that formula.
what calculation is possible by using this?

Q.3 what is an array formula?


please help me by answering the above questions.

sankar Chakraborty

plz solve my querry,if a doctor who is getting professional fees from hospital around 20 lacs and then doctor give a salary to his assistant around 180000 per annum to women doctor. whether doctor should deduct professional tax from this salary paid to assistant... plz solve it ang give a link where i can the act also ( i am from m.p.)

Pls let me know about the form to be submitted for non-contribution of provident fund from my salary & non contribution by my employer

can any member tell me about
1)the treatment of PF & ESI in Income Tax computation of a partnership firm?
2) the due date of deposit of PF & ESI and its rate?
3) consequence of delay in Payment of the same?
4) the ESI & PF of Year 2007-08 is deposited in 2008-09, will it have any effect on the financial statement of 2008-09 of the partnership firm?
5) do we require segreggation of employers and employees contribution to PF in preparing financial statement of a partnership firm?

I used tally 7.2,for my company, it has ladger "contructor" under the group current assets, but the problem is
i cant alter those contructor's address, pan no, etc to the ladger.

plz help me

Hi this is Harheet Singh.

Can any body tell me whther the payment of salary in cash amounting to Rs. 20000 is disallowed or not under Income Tax Act

Query

In a company for doing any business under Factories Act, we need an industrial license. If the company wants to do any other business than whether it requires another industrial license for other business or it has been add on that business in the same industrial license. If it requires a new one, than what is the procedure for it and for this purpose which documents needs to be submitted?

my name is sudarshan agarwal.iwant to use my father's name alongwith my name while applying for membership.
plz help me out.

hi dear,
I have applied for Membership cum COP. I got membership No, but not COP. Can I sign Tax Audit report in my personal name as CA ? if yes, where it is written ?

Dear All,

I cleared Ist group CA Final in the last attempt and couldn reach the examiners expectation in the IInd group and got failed. I am very much worried about cost management(theory part only) and MICS. Can any one help me out by providing some good notes(uploading the file in this website) for cost management theory and MICS theory.

Thanks a lot!