Dear All,

We are using VLOOKUP formula also the result of VLOOKUP is input of another formula. If the result of VLOOKUP is in number, than there is no problem for next dependent formula. But when result of VLOOKUP is “#N/A” (being the corresponding value for VLOOKUP not availed) than the result of next formula also become “#N/A”. Whether it is possible to convert “#N/A” (if the corresponding value for VLOOKUP not availed) to “0” automatically.

Thank You In Advance

Dear Experts,
I wish to pursue CS along with CA.
At present i have registered myself with IGNOU for B.Com.( which is distance learning and as per provisions of ICAI itself ).
I am pursueing CA Articleship as well.
And now want to enroll myself for CS Executive directly without appearing for CS-Foundation Because i am already CPT cleared.

Is it possible for me to pursue both B.com. and CS (both being Distance learning courses) and how should i disclose this in form 112.
Pleases help me out of this.
Thankyou.

In revised schedule Vi advance tax and provision for tax where to show

suppose my tax is 50 and advance tax is 30 or tax is 30 and advance tax is 50
please provide the answer

If profit is Rs.70000/- only
what will be salary to partners.

can you provide me details and process of "HOW TO SURRENDER THE CERTIFICATE OF REGISTRATION OF NBFC OF RBI????"

What was the procedure for applying the PAN and sales tax of a firm...

Is it possible that CA is not having membership number for more than 10 years?(working in industry)
Is there any valid reasons for not taking membership number?

Dear sir,

I am working in one privet firm and along with that i am doing parttime business withj one MNC and i am getting commision.Above 5000 rs commission i have received amont after deduction of tax.can i receive back that amount and if yes than what would be procedure for the same?

Maulik

Sir/Madam,

In regular return,my client has missed one challan.

So,we want to file correction return for that.

We also downloaded nsdl consolidated file.

While importing that consolidated file in rpu 3.5 version,it is showing "temporarily preparation of correction statement for the f.y 2013-14 is not allowed."

When it will be allowed?

Dear Experts,

I have completed my CA in Nov 2008 and CFP in Jan 2012.

I have been working with one of the private company in financial services since last 4 years but i am not satisfied with the type of work i am doing which mostly involves reconcilations. Though it contains some part of accounting and ERP review and recommendations.
Meanwhile, I have got an offer from one of the leading private bank for the position of relationship manager - SME with an annual salary of Rs 7 lacs.
Just wondering if the career as a relationship manager will be a good choice being a CA or there are better choices for Chartered Accountants.

Will welcome your views and opinions.