Anil

Hi,

I have range of cells with forumula which have references to other cells.

For example:: In cell A1 I have forumula "=B1*C1"

In cell A2 I have forumla" =B2*C2"

I want to select these two cells A1 and A2 and make forumulas in them permanent.

For example I want in cell A1 I want the forumula to be "=$B$1*$C$1" and so forth.

How to do this in one stroke for all selected cells. Is there any shortcuts for adding $ sign in formulas in cells?

Thanks


haresh
30 March 2009 at 10:22

Surchare aplicability in TDS

hi..
my company paid to doctor twowards fees Rs. 100000/- so surcharge is applicable when we deducted Tds on this amount U/s 194J


mohan rao
30 March 2009 at 09:47

Set off of Cenvat Credit

Dear Sir,

One of My Client manfacturing seeds and the goods are not excisable and the company purchasing capital items on which excise duty is paying

There is no Outflow of Excise and Customs duty payble from the company

The Company is paying Service Tax under GTA

Shall we offset the Cenvat Credit on Excise duty is to Service Tax payble on GTA

Note : Service Receiver has to pay the Service Tax on GTA

Thanking you


Guest
30 March 2009 at 09:38

194H

I nneed some case laws on 194H of IT Act... TDS on commission received by non-executive directors.If any one have do provide ASAP.


viany
30 March 2009 at 09:23

Bank Reconcilation statement

Why it is necessary to maintain BRS? Give answer in weightage of 20 Marks Or with refrence to 20% Of Any exam.


kamlesh kadam
30 March 2009 at 09:19

VAT Input credit

One of our subsidiaries is located in Andhra Pradesh. It Purchases inputs locally but all its sales come under the purview of central Sales tax. Can Somebody tell me as to hoe much vat input credit can be availed under the Andhra Pradesh Vat ACT ?


Ajay Kumar
30 March 2009 at 09:09

practicle training exemption ICWAI

I am pursuing ICWAI Inter, I have applied for the practicle training exemption as I already have more than 3 years of experience in the accounts field. Now I have received a letter from ICWAI and they are demanding for the company's audited balance sheet and payinslip. I am working on a contract basis in this company I can submit the audit balance sheet but instead of payinslip I can submit the salary certificate is it acceptable Plz guide.


Naiya
30 March 2009 at 09:07

Reimbuesement of expenses

Whether service provider liable to deduct service tax on reimbursement paid to him ?
e.g. if C.A. received reimbursement from client then whether he is liable to deduct service tax on it or not ?


Ajay Kumar
30 March 2009 at 09:01

practicle training exemption ICWAI

I am pursuing ICWAI Inter, I have applied for the practicle training exemption as I already have more than 3 years of experience in the accounts field. Now I have received a letter from ICWAI and they are demanding for the company's audited balance sheet and payinslip. I am working on a contract basis in this company I can submit the audit balance sheet but instead of payinslip I can submit the salary certificate is it acceptable Plz guide.


B R Ramesh
30 March 2009 at 01:28

service tax on retainership charges

Dear Sir

We are Post graduate professional practicing as an auditor & Tax Consultant
we are providing legal service to our clients on Central excise, Service tax & VAT etc.

we charging our fees as retainership charges for this whether service tax applicable or exempt.






CCI Pro
Meet our CAclubindia PRO Members

Follow us



Answer Query