Hi, I am trying to return "1" if both B37 is "9AM" AND C37 is "D1".
Thank you,
Luke
Hi, I am trying to return "1" if both B37 is "9AM" AND C37 is "D1".
Thank you,
Luke
is 9AM a time or TEXT ?
if text
=IF( AND ( B37 = "9AM", C27 = "D1" ) , 1 , "" )
If its a TIME
IF ( AND ( B37 = TIMEVALUE("09:00") , C27 = "D1" ) , 1 , "" )
Wayne
if my assistance has helped, and only if you wish to , there is an "* Add Reputation" on the left hand side - you can add to my reputation here
If you have a solution to your thread - Please mark your thread solved do the following: >
Select Thread Tools-> Mark thread as Solved. To undo, select Thread Tools-> Mark thread as Unsolved.
Thank you! It is text. If I want to cover a range for "D1" instead of a single cell, what would the formula be? For example, the range would be C37:M42.
is this still just to us the formula in 1 cell?
Whats in C37 to M42 ?
Are you looking for any value of D1 to exist in that range
Then
IF( AND( Countif(C37:M42 , "D1" ) >0 , B37 = TIMEVALUE("09:00") ) , 1 , "")
Countif(C37:M42 , "D1" ) >0
Is counting how many times D1 appears in that range , C37 to M42 and if the count is more than zero - ie D1 exists then thats TRUE
AND with the time in B37 , gives the result
but not sure that is what you meant
can you mock up a spreadsheet and expected result - see yellow banner
Thank you! Yes, I was looking for any value of D1 to exist in that range. Your formula worked perfectly, thanks again!
excellent
you are welcome
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks