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