**Question description:**

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

I need help with the formula if then
I have =IF(Q4=".",".", IF((Q4>=6,Q4<28)"1","0")))
But its not working

Solved by B. J. in 15 mins

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

Excelchat Expert
07/09/2017 - 10:30

Thanks for choosing Got It Pro. I’m happy to be able to help you today.

User
07/09/2017 - 10:30

Great

Excelchat Expert
07/09/2017 - 10:31

I’d love to help you with your problem if you would kindly give me more information.

User
07/09/2017 - 10:31

Please look at document on right

User
07/09/2017 - 10:32

I would like it to put 1 if A1 >=6

Excelchat Expert
07/09/2017 - 10:32

Please write actual result on Column c

User
07/09/2017 - 10:32

what do u mean results?

User
07/09/2017 - 10:32

i dont have results

User
07/09/2017 - 10:32

I would like it to put 0 if A1 <6

Excelchat Expert
07/09/2017 - 10:32

ok then let me know what i have to do

Excelchat Expert
07/09/2017 - 10:32

ok

User
07/09/2017 - 10:32

I would like it to put 1 in B if A1 >=6

User
07/09/2017 - 10:33

I would like it to put 0 in B if A1 <6

User
07/09/2017 - 10:33

I would like it to put . in B if A1 .

Excelchat Expert
07/09/2017 - 10:33

ok

Excelchat Expert
07/09/2017 - 10:33

Now we can continue into the explanation step of this session. I am going to perform the following: I am making formula now

User
07/09/2017 - 10:33

I would like it to put 0 in B if A1 > 28

User
07/09/2017 - 10:33

The formula I have is working except for ^

User
07/09/2017 - 10:34

Not working for (I would like it to put 0 in B if A1 > 28 )

Excelchat Expert
07/09/2017 - 10:34

ok

User
07/09/2017 - 10:34

Thats what i need

User
07/09/2017 - 10:35

any questions for me?

Excelchat Expert
07/09/2017 - 10:35

no i am try to make this

Excelchat Expert
07/09/2017 - 10:35

Please stay here

User
07/09/2017 - 10:35

okay

Excelchat Expert
07/09/2017 - 10:37

What will be the result if A1 is =28

User
07/09/2017 - 10:37

1

Excelchat Expert
07/09/2017 - 10:37

ok

Excelchat Expert
07/09/2017 - 10:41

I’ve completed the solution, take a look if you would like. We can now continue to the discussion stage and I can answer any questions you may have with the solution I provided.

User
07/09/2017 - 10:41

okay, let me look

Excelchat Expert
07/09/2017 - 10:42

ok

User
07/09/2017 - 10:44

it worked

User
07/09/2017 - 10:44

thank you!

User
07/09/2017 - 10:44

have a nice day

Excelchat Expert
07/09/2017 - 10:44

Welcome

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