Excel - IF Function Problem - Expert Solution

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.

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.

Click here to get your free Excelchat help session

Subscribe to Excelchat.co
Trusted by people who work at
Amazon.com, Inc
Facebook, Inc
Accenture PLC
Siemens AG
Macy's
The Allstate Corporation
United Parcel Service
Dell Inc