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
- Is this income indian or foreign income?
- RCM applicability on Rent Paid by Registered Person to Unregistered Landlord for Residental Building
- GST on export of services and Input Credit
- ITC temporary reversal and reclaim
- Inventory of finished goods
- Applicable TDS rate for sale of property in Nov 2024
- Tds on building rent monthly
- GST ON EXPORT COMMISSION
- Can we claim ITC of Feb-2024 in the month of November-2024 which was not claimed by oversight
- REGARDING 25 AS DATE OF PAYMENT AND DATE OF BOOKING
- LAST YEAR 2022-23 ITC IN NEXT YEAR 2023-24 REPORITNG IN GSTR-9
- MIS MATCH OF INVOICE NUMBER
- IGST Credit-Show cause notice issued-confusion
- Issue of gst e invoice
- How to adjusted advances given or receipt
- Foreign vendor without PAN unable to to register due to non receipt of OTP on foreign number ?
- 133(6) DIN INVALID format error - ->WHERE TO REPLY 133(6) notice?
- Query for dubts
- Regarding einvoice taken on nil rated sales
- Strategical investment in Public listed company
Trending Online Classes
CAclubindia
