MS EXCEL LOOKUP FUNCTION

This query is : Resolved

CA Abhishek Singh (Querist)
Follow

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

Kamaraj Mani. N

Kamaraj Mani. N (Expert)
Follow

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