# Excel - AVERAGE Function Problem - Expert Solution

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
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.

Get instant expert help with Excel and Google Sheets

#### Post your problem and you’ll get expert help in seconds.

Your message must be at least 40 characters
Your privacy is guaranteed. Your session will not be used for blog unless you give us persmission.