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
- About TDS & Income Tax
- Pass word to open justification report for Q1 for FY 2026-27
- Section 194JA & JB Income which ITR Form to use
- Scrutiny and reopening of past returns
- PPF interest-As Exempt Income disclosure
- Booth for sales promotion
- Type of Capital Gain
- F & O PROFIT REPORTING FOR AY 2026-27
- Average Cost Of High Quality Diamonds
- ITR 4 OR ITR 3 WHICH FORM CHOOSE
- TDS on Rent received on redevelopment of building
- Tax on Deemed Capital Gain
- Indian IT Portal issue in computing tax as per UK-India DTAA
- Capital Gains on sale of residential flat
- Upload Level ValidationITR3Category of Defect B/D
- PF Taxable Income
- Clarification on Tax Audit Applicability and Reporting of F&O Transactions in ITR-3
- Interest credited in FY2025-2026 & TDS therein by EPFO does not reflect in AIS or Form 26AS
- 44ad eligble money lending interest
- Taxation in the hands of Landowner under JDA
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
