How to get information by using formula
This query is : Resolved
09 August 2010
Let me present here a summarized worksheet
Supp Name Item Des Value VAT rate Vat amt
Asha Entp 775 4 31
Asha Entp 3415 12.5 426.88
Let me present here a summarized worksheet
Supp Name Item Des Value VAT rate Vat amt
Asha Entp 775 4 31
Asha Entp 3415 12.5 426.88
09 August 2010
LET TAKES
COLUMN A : SUPPLIER NAME
COLUMN B : ITEM DESCRIPTION
COLUMN C : VALUE OF PARTICULAR ITEM COLUMN D : VAT RATE ( FEED RATE MANUALLY)
COLUMN E : VAT VALUE ( IN THIS ROW/COLUMN
= C2*D2/100
ASSUMING ROW 1 IS USED FOR DESCIRIPTION OF COLUMN HEADING AND DATA IS FEEDING IN ROW 2.
COLUMN A : SUPPLIER NAME
COLUMN B : ITEM DESCRIPTION
COLUMN C : VALUE OF PARTICULAR ITEM COLUMN D : VAT RATE ( FEED RATE MANUALLY)
COLUMN E : VAT VALUE ( IN THIS ROW/COLUMN
= C2*D2/100
ASSUMING ROW 1 IS USED FOR DESCIRIPTION OF COLUMN HEADING AND DATA IS FEEDING IN ROW 2.
You need to be the querist or approved CAclub expert to take part in this query .
Click here to login now
Click here to login now
Similar Resolved Queries
Unanswered Queries
- TDS 194-T applicability
- Fixe term employment
- Is any professional CA is here please reply
- GST ITC REVERSE
- Regarding Applicability of Tax Audit u/s 44AB
- Foreign lottery ticket bought online from India: legality, tax and consequences
- Reprocessing of rectification order AY 2025-26
- Section 50-fixed asset-->building ceases to exist
- TDS on TRUST
- Consolidated financials
- Withdrawal in cash from partners capital account by partner
- Regime change
- Goods sold but invoice not issued
- Tally: Imported bank entries do not show up in manual reconciliation
- Sales of goods of amount Rs97 lakhs to a party
- Confused About My Career After 12th — Cyber Security, AI or Finance? Need Guidance
- STATUTORY AUDIT OF A SMALL PRIVATE COMPANY INCORPORATED ON 28.03.2025
- Guidance Needed: Linking Multiple Form 26QB Payments and Responding to ITD Defaulter Notice
- How to pay remaining amount of TDS after due date?
- Resigning a auditor from the company for misconduct
Trending Online Classes
-
DT & Audit (Exam Oriented Fastrack Batch) - For May 26 Exams and onwards Full English
CA Bhanwar Borana & CA Shubham Keswani
Subscribe to Pro
Join an elite circle of professionals
CAclubindia
