[go: up one dir, main page]
Scribd
Upload
4 views7 pages

Switch Function

The document contains multiple examples of data tables related to salespersons, grades, states, and sales commissions. Each example presents different types of information, such as product ratings, average grades, state codes, and sales figures with commission percentages. The data is organized in a structured format for easy reference.

Uploaded by

Sathish Loal
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as XLSX, PDF, TXT or read online on Scribd
4 views7 pages

Switch Function

The document contains multiple examples of data tables related to salespersons, grades, states, and sales commissions. Each example presents different types of information, such as product ratings, average grades, state codes, and sales figures with commission percentages. The data is organized in a structured format for easy reference.

Uploaded by

Sathish Loal
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as XLSX, PDF, TXT or read online on Scribd
You are on page 1/ 7

EXAMPLE-1

Sales Persons Product Rating Rank Rating Rank


GANESH SAMSUNG 4 Very Good 1 Poor
MAHESH LENOVO 1 Poor 2 Average
PRASAD APPLE 4 Very Good 3 Good
RAJU ACER 2 Average 4 Very Good
RAMESH LAVA 2 Average 5 Excellent
RAMYA F&D 5 Excellent
RAVI IQ003 4 Very Good
SESHU LG 3 Good
SONU SANSUI 3 Good
SURESH MOTO 5 Excellent
EXAMPLE-2
NAME AVG GRADE
GANESH 87.67 A AVG GRADE
MAHESH 55.00 C 80-100 A
PRASAD 53.33 C 60-79 B
RAJU 81.00 A 50-59 C
RAMESH 51.00 C <50 D
RAMYA 60.33 B
RAVI 58.67 C
SESHU 64.33 B
SONU 69.67 B
SURESH 47.33 D
VINAY 52.00 C
IF(B4>=80,"A",IF(B4>=60,"B",IF(B4>=50,"C","D")))
EXAMPLE-3
STATE CODE
Andhra PradeshAP
Telangana TG Andhra PradesAP
Delhi DL Telangana TG
Andhra PradeshAP Delhi DL
Kerala no code
Odisha no code
Delhi DL
Andhra PradeshAP
Karnataka no code
EXAMPLE-4
Sales Persons Sales Comm(%) Sales Comm(%)
GANESH 13500 405 >50,000 10%
MAHESH 7500 0 >30,000 5%
PRASAD 32500 1625 >10,000 3%
RAJU 22500 675 <=10,00 0%
RAMESH 57500 5750
RAMYA 6500 0
RAVI 8800 0
SESHU 14000 420
SONU 4000 0
SURESH 35000 1750
omm(%)
EXAMPLE-5
Dates Day
### week day Monday Weekday 1
### weekend Tuesday Weekday 2
### week day WednesdayWeekday 3
### weekend Thursday Weekday 4
### week day Friday Weekday 5
### week day Saturday Weekend 6
### weekend Sunday Weekend 7
### week day
### week day
### weekend

You might also like