# Excel - IF Function Problem - Expert Solution

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

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.