MS EXCEL LOOKUP FUNCTION
This query is : Resolved
22 February 2010
HELLO EVERYONE
PLEASE SOLVE THE FOLLOWING EXCEL PROBLEM
NAME GENDER CITY GRADE BASIC
RX M A 10000
LDJF F B 15000
USE LOOKUP FUNCTION AND CALCULATE
HRA 30% OF BASIC FOR A GRADE CITY
20% OF BASIC FOR B GRADE CITY
10% OF BASIC FOR C GRADE CITY
DA 20% OF BASIC IF BASIC IS <=10000
15% OF BASIC OTHERWISE
ALSO FIND GROSS PAY AS GROSS = BASIC+HRA+DA
ALSO FIND TAX AS
10% OF GROSS FOR FEMALE
15% OF GROSS FOR MALE
MY ID abhipcc@rediffmail.com
PLEASE SOLVE THE FOLLOWING EXCEL PROBLEM
NAME GENDER CITY GRADE BASIC
RX M A 10000
LDJF F B 15000
USE LOOKUP FUNCTION AND CALCULATE
HRA 30% OF BASIC FOR A GRADE CITY
20% OF BASIC FOR B GRADE CITY
10% OF BASIC FOR C GRADE CITY
DA 20% OF BASIC IF BASIC IS <=10000
15% OF BASIC OTHERWISE
ALSO FIND GROSS PAY AS GROSS = BASIC+HRA+DA
ALSO FIND TAX AS
10% OF GROSS FOR FEMALE
15% OF GROSS FOR MALE
MY ID abhipcc@rediffmail.com
22 June 2010
Please read this Tutorial
https://www.caclubindia.com/share_files/vlookup-new-usage-3240.asp
Download the file (As per your requirement)
https://www.caclubindia.com/share_files/vlookup-why-true-false--27811.asp
https://www.caclubindia.com/share_files/vlookup-new-usage-3240.asp
Download the file (As per your requirement)
https://www.caclubindia.com/share_files/vlookup-why-true-false--27811.asp
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
- CAPITAL GAIN BASE ON NOTIFICATION
- Unregistered suppliers utility
- ITDS U/S.194T of Firm
- NRI starting business in India
- Difference between Date of Payment and Date of Deduction?
- Journal entry of busniess expenses
- GST not cancelled by tenant
- FORM 141 SDV query
- URGENT-Eligible leaves being shown as 24 days for 3 years Articleship instead of 156 days in 108
- Cash balance limit and property purchases limit
- Taxable or Tax exempt
- How to pay remaining amount of TDS after due date?
- RCM @ 5% on Hamali charges, Transport Charges, Unloading charges we take ITC or not
- CALCULATION OF DEFFERED TAX - OP BL IS DTL & CURRET IT DTA
- LLP audit under companies act
- Experienced CA recommendation from Kolkata for FNO return filing
- Interest Reporting in Form 168
- Sales of goods of amount Rs77 lakhs to a party
- Tax Demand of ₹4,650 for AY 2026-27
- Concept of Vendor and customner reconciliation
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
