**Question description:**

*This user has given permission to use the problem statement for this blog.*

Compute the weighted average of students score from a spreadsheet using different weight for each category of marks

Solved by G. E. in 20 mins

This is the chat thread from the real Excelchat help session. It contains no private user information.

Excelchat Expert
13/12/2017 - 07:43

Hello!

Excelchat Expert
13/12/2017 - 07:43

welcome to excelchat

Excelchat Expert
13/12/2017 - 07:43

can i see the data on which you want this?

User
13/12/2017 - 07:43

hey

User
13/12/2017 - 07:44

just a random example

User
13/12/2017 - 07:44

based on that question

User
13/12/2017 - 07:44

as simple as you can make it

Excelchat Expert
13/12/2017 - 07:44

ok can you create a dummy data for me

Excelchat Expert
13/12/2017 - 07:44

ok i got you

Excelchat Expert
13/12/2017 - 07:44

i will create that

User
13/12/2017 - 07:45

thank you

Excelchat Expert
13/12/2017 - 07:45

weight for each category of marks are?

User
13/12/2017 - 07:46

yeh

User
13/12/2017 - 07:46

is this all free

User
13/12/2017 - 07:46

i can do this again

Excelchat Expert
13/12/2017 - 07:46

yes you can do this again

Excelchat Expert
13/12/2017 - 07:47

but there are three free sessions

Excelchat Expert
13/12/2017 - 07:47

after that there is charges which are listed there

User
13/12/2017 - 07:47

alright

Excelchat Expert
13/12/2017 - 07:48

can you tell me weight for categories?

User
13/12/2017 - 07:48

idk what the categories is

User
13/12/2017 - 07:48

its based on school

Excelchat Expert
13/12/2017 - 07:48

ok

User
13/12/2017 - 07:48

testst

User
13/12/2017 - 07:48

getting

User
13/12/2017 - 07:48

weighted avg

Excelchat Expert
13/12/2017 - 07:49

lets take is as 20 to 50 and 50 to 100

Excelchat Expert
13/12/2017 - 07:49

and 10 to 20

Excelchat Expert
13/12/2017 - 07:50

sorry 0 to 20

User
13/12/2017 - 07:53

Using the Logical IF function, compute the tax on income with two (2) tax brackets.

User
13/12/2017 - 07:53

can u show that next

Excelchat Expert
13/12/2017 - 07:54

yes sure

Excelchat Expert
13/12/2017 - 07:54

weighted average is done

User
13/12/2017 - 07:54

i took

User
13/12/2017 - 07:54

pic

User
13/12/2017 - 07:54

thank you

Excelchat Expert
13/12/2017 - 07:54

your most welcome

Excelchat Expert
13/12/2017 - 07:55

you want to calculate tax right?

User
13/12/2017 - 07:55

using if function'

Excelchat Expert
13/12/2017 - 07:55

ok

User
13/12/2017 - 07:55

Using the Logical IF function, compute the tax on income with two (2) tax brackets.

Excelchat Expert
13/12/2017 - 07:55

ok sure

User
13/12/2017 - 07:58

so for the first question I'm just adding weight together and multiplying marks by weight

User
13/12/2017 - 07:58

then diving sum of marks times weight by the weight totoal

Excelchat Expert
13/12/2017 - 07:59

can you see the tax working?

User
13/12/2017 - 07:59

yeh

User
13/12/2017 - 07:59

it said error for first one

User
13/12/2017 - 07:59

but shows

Excelchat Expert
13/12/2017 - 08:00

so for the first question I'm just adding weight together and multiplying marks by weight," exactly"

Excelchat Expert
13/12/2017 - 08:00

then diving sum of marks times weight by the weight totoal, yes

Excelchat Expert
13/12/2017 - 08:00

now its not showing error

User
13/12/2017 - 08:00

its not showing error

User
13/12/2017 - 08:00

but still lost for the 2nd question

Excelchat Expert
13/12/2017 - 08:01

in 2nd question i have added 2 slab rates

Excelchat Expert
13/12/2017 - 08:01

where if income is less then 250000 then nil tax

Excelchat Expert
13/12/2017 - 08:01

250000 to 500000 20%

Excelchat Expert
13/12/2017 - 08:01

and above that its 30%

Excelchat Expert
13/12/2017 - 08:02

its like that

Excelchat Expert
13/12/2017 - 08:02

got it?

User
13/12/2017 - 08:02

it has to be less

User
13/12/2017 - 08:02

then 25000

User
13/12/2017 - 08:02

in order to gain tax

Excelchat Expert
13/12/2017 - 08:02

yes

User
13/12/2017 - 08:03

thank you

User
13/12/2017 - 08:03

ill try to figure out

Excelchat Expert
13/12/2017 - 08:03

do you have further queries regarding this question?

**This is the output file from the real Excelchat help session:**

*This is an example of the expert help you can get. It contains no private user information.*