My question is related to IF Function in Excel for HRA Amount Formula

Write formula for HRA Amount in B2 Cell under two condition if Basic salary is in A2

Condition no. 1 :- If salary is upto 15000,HRA will be 40% of Basic Salary with a minimum amount of HRA is Rs. 3000


Condition no. 2 :- If salary is more than Rs.15000,HRA will be 30% of Basic Salary with a maximum amount of HRA Rs. 10000

Both condition's formula written separately

DEAR SIR,

I COME TO KNOW THAT LAST FEW YEAR MORE THAN 2 LACS AMOUNT CREDITED AGAINST A CREDITOR (LTD. CO)IN OUR BALANCE SHEET WRONGLY.

SO HOW COULD I WRITE IF OFF SAFELY IN THIS YEAR FOR FARE ACCOUNTING

I AM CONFUSED. PLS ANY BODY HELP ME

THANK YOU

What is entry in books of account for DTAA?
Rs.100 is Prof Fee
Rs.20 is Tax paid in UK
Rs.80 Net Amoount.
Is there any Tax Treatment/Exemption in our Books or IT return?

i m student in fY bcom so plz tell mi about my quary give ans. as early as possible.

1)if purchase machine but it not related to business. that time what is a entry book in tallyERP9

2)if purchase cartridge but it not related to business. that time what is a entry book in tallyERP9
plz give sugession.

Dear friends,

I have a doubt regarding bad debts provision. what happened was in order to bring down profit, i picked some old debtors and transferred them to bad debts account.But instead of crediting the debtors ledger i created another head under debtors as provision for doubtful and bad debts and passed the entry as follows :

Bad Debts a/c Dr
To Provision for Bad & Doubtful debts.

My question is in case after mayb 1 or 2 years if any of the above debtors settle or give us credit note, what will be the treatment in that particular year..such that the amount can be credited from the debtor account and provision for bad and doubtful debts account too..

Pls reply asap and thanks a lot for the reply in advance...

Dear sir

in one my clients accounts, pre operative expense of Rs 12000 was capitalised along with fixed assets and depreciation was charged on the total amount in the next years.
is'nt it wrong?
how should we treat it?

As new Indian accounting standards are released, what will be the applicability of accounting standards for exam. will it be Ind As or AS or both?

A ltd has paid service tax on income earned from business auxiliary services rendered by them during past few years. They had not accounted service tax liability in the books at the time of receipt. whether the payment can be treated as prior period expense in the current years financial statements?
what will be its treatment in computation of income tax?

A company Manufactures cement, it is constructing a wagon trippler to carry the Coal, Whether we can say the Wagon Trippler a Qualifying asset under As- 16 & Capitalise the Borrowing Cost During the contruction period?

Dear Experts,

Pls suggest me what will be the journal entry for following transaction.

"Last year Educational trust is working on Cash Basis so the trust is not calming the depreciation on Fixed assets but due to audit objection trust changes its method to mercantile basis in current year, so pls tell me what will be the entry for calming depreciation for last year and current year in the books of accounts for current year"