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
- TDS Challan - change of FY 2025-26 to TY 2026-27
- Price inclusive or exclusive of GST while made entry in P& L Account
- Gst registered proprietorship firm
- Dep. as per companies act
- Applicability of GST on Salary Reimbursement Component
- AUDITOR APPOINTMENT FOR THE YEAR ENDING MARCH 27
- Minimum tax payable to file Updated return
- UDIN ISSUE
- Change Of Karta In Case of Death
- TDS on purchase of under construction property from a reseller
- Non filing of I T Returns
- How to Handle Active E-Invoices in GST Portal Deleted from Tally?
- IMPORT PURCHASE ENTRY PASSED IN BOOKS OF ACCOUNT
- FAST DS 26 Undisclosed Foreign Asset Disclosure Scheme 2026
- Starting trading business
- 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
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
