# Excel - AVERAGE Function Problem - Expert Solution

Question description:
This user has given permission to use the problem statement for this blog.

IF(AVERAGE(C6+E6+G6)>=5000,TRUE,FALSE) I am using AND function and it is not giving me the correct answer
Solved by G. J. in 24 mins
This is the chat thread from the real Excelchat help session. It contains no private user information.
Excelchat Expert 17/09/2018 - 02:49
Hello, Welcome to Got it Pro.
Excelchat Expert 17/09/2018 - 02:50
Excelchat Expert 17/09/2018 - 02:51
In which cell, are you using the and function?
User 17/09/2018 - 02:51
J and K
Excelchat Expert 17/09/2018 - 02:51
You working on excel or google sheets?
User 17/09/2018 - 02:51
if cell I is 5000 it should be true
User 17/09/2018 - 02:52
excel
Excelchat Expert 17/09/2018 - 02:52
User 17/09/2018 - 02:52
I cannot share the file but data is what i have paste it
Excelchat Expert 17/09/2018 - 02:52
right now there is no formula I can see in Col J and K at the right side of the screen
Excelchat Expert 17/09/2018 - 02:52
Ok
User 17/09/2018 - 02:52
this is only data I have
Excelchat Expert 17/09/2018 - 02:52
let me create it from fresh
Excelchat Expert 17/09/2018 - 02:53
So I have a few quick questions before I start
Excelchat Expert 17/09/2018 - 02:53
You want the results as True and False right?
User 17/09/2018 - 02:53
yes
Excelchat Expert 17/09/2018 - 02:54
based on average of C, E and G column
User 17/09/2018 - 02:54
yes
Excelchat Expert 17/09/2018 - 02:54
if average is greater or equal to 5000 then true otherwise false
User 17/09/2018 - 02:54
yes that
Excelchat Expert 17/09/2018 - 02:54
ok
Excelchat Expert 17/09/2018 - 02:55
Thanks for explanation, let me have a look
Excelchat Expert 17/09/2018 - 02:57
One more thing, what is the difference between J and K
Excelchat Expert 17/09/2018 - 02:57
In J you will get the result as true and false
Excelchat Expert 17/09/2018 - 02:57
based on C, E and G columns but what is in K column?
User 17/09/2018 - 02:57
J I was trying to get result if 3 cell meets 5000
User 17/09/2018 - 02:58
K was trying to average it
Excelchat Expert 17/09/2018 - 02:58
meets means? the sum?
User 17/09/2018 - 02:58
mean each cell criteria is 5000
Excelchat Expert 17/09/2018 - 02:59
that means if C or E or G any of the cell have a value which is greater or equal to 5000 it should say true?
User 17/09/2018 - 02:59
corretc
User 17/09/2018 - 02:59
correct
Excelchat Expert 17/09/2018 - 02:59
ok, will create that as well.
Excelchat Expert 17/09/2018 - 02:59
You can see Col K for now for average values, I am creating fro col J
Excelchat Expert 17/09/2018 - 03:00
Col J - =IF(OR(C2>=5000,E2>=5000,G2>=5000),TRUE,FALSE)
Excelchat Expert 17/09/2018 - 03:00
Col K- =IFERROR(IF(AVERAGE(C2,E2,G2)>=5000,TRUE,FALSE),False)
Excelchat Expert 17/09/2018 - 03:01
You can see at the right side of the screen as well.
Excelchat Expert 17/09/2018 - 03:01
User 17/09/2018 - 03:01
check out row 6 how that is true??
User 17/09/2018 - 03:01
that is where i am stuck at
Excelchat Expert 17/09/2018 - 03:02
Ok, I got it... so there are data errors in C2 and E2
User 17/09/2018 - 03:03
there is no data it is emty
Excelchat Expert 17/09/2018 - 03:03
So it should take as 0 right
User 17/09/2018 - 03:03
yes
Excelchat Expert 17/09/2018 - 03:03
C2=0, E2=0, G2=10080
Excelchat Expert 17/09/2018 - 03:03
let me deal with it
Excelchat Expert 17/09/2018 - 03:05
Have a look now
Excelchat Expert 17/09/2018 - 03:05
IS it fine, now?
User 17/09/2018 - 03:05
yes'
Excelchat Expert 17/09/2018 - 03:06
Please end the session, I will appreciate a 5 star rating. I will also provide a 5 star rating for you so that you get the best expert next time.
Excelchat Expert 17/09/2018 - 03:06
Thanks for using Got it Pro. Looking forward to help you further. Appreciate it :)
Excelchat Expert 17/09/2018 - 03:06
Have a good day.
User 17/09/2018 - 03:06
Excelchat Expert 17/09/2018 - 03:07
there was some error in the cells, I mean excel was unable to read the data
User 17/09/2018 - 03:07
can check column K same row
User 17/09/2018 - 03:07
how did you fic it
User 17/09/2018 - 03:07
fix it
Excelchat Expert 17/09/2018 - 03:08
copied and pasted the 0's from above cells
Excelchat Expert 17/09/2018 - 03:08
Excel read the data in certain way.
Excelchat Expert 17/09/2018 - 03:08
So, if you want to use average formula excel should read the value from the cell
Excelchat Expert 17/09/2018 - 03:08
All set now?
Excelchat Expert 17/09/2018 - 03:10
Are you still with me?
User 17/09/2018 - 03:10
One more thing can i right between number
Excelchat Expert 17/09/2018 - 03:11
User 17/09/2018 - 03:11
Like between 5900 to 7000 if criteria meets ture
Excelchat Expert 17/09/2018 - 03:11
yeah you can do that as well
User 17/09/2018 - 03:12
can u do on J
Excelchat Expert 17/09/2018 - 03:13
As per the got it pro policy, I am allowed to solve only one query in one session, I have already created two formula's. I request you to raise another session for further queries. I hope you understand.
Excelchat Expert 17/09/2018 - 03:13
Please end the session, I will appreciate a 5 star rating. I will also provide a 5 star rating for you so that you get the best expert next time. Thanks for using Got it Pro. Looking forward to help you further. Appreciate it :)

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.