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
- SEC 54 OF IT ACT
- Form 26QB for TDS on property
- Where to show the RCM on Rent paid to unregistered landlord
- Is Aadhar PAN linking required for opening bank account?
- CPC Processing IT Return for AY 2023-24 without recognizing the Taxation Option under New Regime
- BLOCKED-INELIGIBLE GST CREDIT
- Amendment of September 2021 Invoice
- RCM - commercial rent paid to URP under GST
- Offsetting interest income against derivative trading losses
- Whether still royalty
- Input credit reversal for the FY2023-24
- Regarding Form 15CA & CB
- Issue of gst e invoice
- Interchangeable words in accounts
- Adjusted profit/Loss in the case of LLP and Pvt. Ltd.company
- 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 Resignation by Auditor from Pvt. Ltd.
Trending Online Classes
-
Excel Mastery Program
CA Rishabh Pugalia
CAclubindia
