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
How may I help you today?
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
Please forward me the sheet so that I can help you better.
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
Does this solve your query?
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
what you had it to
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
please explain, i did not get your question
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.
