IF AND Formula

[jh3268]

Having some issues trying to input an IF AND formula. I have Columns A-I but need conditions to be met on two of these.

Column B is a date/time
Column H is formatted with conditional formatting to Show either blank or YES.

I need the formula to show as TRUE if the date in Column B is more than 24 hours old from the current date/time AND I need Column H to show YES in the dropdown. If not true, I would like to leave blank, but it FALSE is needed, I can work with that.

Any help would be much appreciated!

 

[dreid1011]

Perhaps something like this:

=IF(AND(TEXT(NOW()-B2,"[h]")*1>24,H2="Yes"),TRUE,"")

 

[jh3268]

Perhaps something like this:

=IF(AND(TEXT(NOW()-B2,"[h]")*1>24,H2="Yes"),TRUE,"")

That worked perfectly, thank you so much!

 

[Peter_SSs]

Perhaps something like this:

=IF(AND(TEXT(NOW()-B2,"[h]")*1>24,H2="Yes"),TRUE,"")

I don't understand the logic of turning the numerical data into text with the TEXT function and then forcing the result back to numerical by multiplying by 1?
Wouldn't this (keeping everything numerical) do the same thing?

=IF(AND(NOW()-B2>1,H2="YES"),TRUE,"")

 

[dreid1011]

I don't understand the logic of turning the numerical data into text with the TEXT function and then forcing the result back to numerical by multiplying by 1?
Wouldn't this (keeping everything numerical) do the same thing?

=IF(AND(NOW()-B2>1,H2="YES"),TRUE,"")

Because I am not well experienced with date/time functions and don't know how the decimal portion breaks down into hours/minutes/seconds, so converting to something that actually read as "24" instead of 1.xxx made sense to me. I know it's been posted here before, but I usually avoid answering any time/date related questions.

 

[Peter_SSs]

Because I am not well experienced with date/time functions ..

Fair enough.

I usually avoid answering any time/date related questions.

To be honest I tend to be a bit the same, though I am getting a bit more adventurous.