Vlookup h lookup countif, and if lessthan /greater than form
This query is : Open
05 November 2017
DEAR SIR,
PLEASE PROVIDE THE BEST EXAMPLES FOR V LOOK UP AND H LOOKUP AND PIVORT TABLE AND IF 5000 SALES CROSSED THEN SALES MAN GET 5% COMMISION LIKE THIS FORMULAE I NEED TO PUT IN EXCEL PLEASE ELABORATE THESE
PLEASE PROVIDE THE BEST EXAMPLES FOR V LOOK UP AND H LOOKUP AND PIVORT TABLE AND IF 5000 SALES CROSSED THEN SALES MAN GET 5% COMMISION LIKE THIS FORMULAE I NEED TO PUT IN EXCEL PLEASE ELABORATE THESE
05 November 2017
1st Use 'If' in Main Sheet to add a column "Commission", Formula will be =if(A1>5000,A1*5%,0)
2nd use 'pivot table, by selecting all the required field and by removing the blank column in Commission by using filter
05 November 2017
Vlookup & Hlookup is almost same. one is for vertical & he other is for horizontal
05 November 2017
If you want how to use the formula you may search video on youtube
05 November 2017
Most Welcome Venu Ji
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
- Post Office RD Interest
- Building and other construction workers welfare cess act 1996
- Eway bill for machinery reparing
- Applicable TDS for Purchase of Flat from NRI
- ITR 3 FILING OF AN INDIVIDUAL (PARTNER IN A PARTNERSHIP fIRM)
- Bank Accounts in Balance Sheet for ITR 3
- TDS ON CASH WITHDRAWALS...
- Annual return of gst limit
- Form 10BD Filling
- Registration as Authorised Representative of minor
- ESIC- Employee Registration
- Delisted shares sold in off market/ Rebate u/s87A
- In Exports Sales HSN details where to fill
- Opting out" of regime provided under subsection (1A) of Section 115BAC but Form 10IEA is not filed.
- Difference in tax comparison report
- Gst invoice numbering and delivery challan numbering
- Sales amount in Gstr1
- E Commerce GSTR1 & 3B how to file
- GST Cancellation without jurisdiction
- Legal Opinion on Registrar's Refusal to Investigate a Society for Non-Renewal and Non-Compliance
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
