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.