Question description:
This user has given permission to use the problem statement for this
blog.
HI I need help with an If and and statement formula... for some reason it's not working for me
Solved by V. U. in 26 mins
This is the chat thread from the real Excelchat help session. It contains no private user
information.
User
07/09/2017 - 05:57
hello , i was using the formula if and and but its not working i was using this formula on column F
User
07/09/2017 - 05:57
=if(and(e2=1,d2<=b2),1,0)
User
07/09/2017 - 05:58
I want to confirm that the person who arrived during their appt date also arrived on time by time
User
07/09/2017 - 05:58
im sorry the formula i was using actually looks like this
User
07/09/2017 - 05:58
=if(and(e2=1,d2<=b2+30),1,0)
User
07/09/2017 - 05:59
I was giving them a 30 minute grace period to arrive, other wise it would be late
Excelchat Expert
07/09/2017 - 05:59
let me check, please give me a moment
User
07/09/2017 - 05:59
ok
User
07/09/2017 - 06:06
?
Excelchat Expert
07/09/2017 - 06:08
I am working on it
Excelchat Expert
07/09/2017 - 06:08
give some time
User
07/09/2017 - 06:10
ok
Excelchat Expert
07/09/2017 - 06:15
Ok
Excelchat Expert
07/09/2017 - 06:15
You can't add integer directly to time formula
Excelchat Expert
07/09/2017 - 06:16
if you want to add hrs in time then you have to first divide your number (in this case its 30) with 24 and then add it
Excelchat Expert
07/09/2017 - 06:17
if you want to add seconds then divide the number with 1440
Excelchat Expert
07/09/2017 - 06:18
Sr if you want to add minutes then divide the number with 1440
Excelchat Expert
07/09/2017 - 06:18
and if you want to add seconds then divide the number with 86400
Excelchat Expert
07/09/2017 - 06:19
i suggest you first divide the number (if hrs then 30/24) in seperate cell and change the format of the cell to time and then use that cell in the formula
Excelchat Expert
07/09/2017 - 06:20
it is the best and the easiest way to solve this type of problem
Excelchat Expert
07/09/2017 - 06:20
please confirm if i gave you the right solution
Excelchat Expert
07/09/2017 - 06:21
Thanks for using Got It Pro-Excel Please give your kind feedback for our service Have a good day ahead
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.