KolbyPanda
New Member
- Joined
- Jul 3, 2018
- Messages
- 6
Greetings! I've searched around for combining IF commands for a single cell but I may be using the wrong termonology because I am not figuring it out. .
I need to query one cell and display the result on the next tab. I believe my functions are the best for this but I am unable to combine them.
Im working on a separate sheet (Sheet2) with this query
=IF(ISNUMBER(SEARCH("20:00 - 00:00",'Sheet1'!B135)),"NIGHT","")
=IF(ISNUMBER(SEARCH("08:00 - 20:00",'Sheet1'!B135)),"DAY","")
=IF(ISNUMBER(SEARCH("08:00 - 00:00",'Sheet1'!B135)),"24HRS","")
Im asking for a cell to display Day, Night or 24 based on the other sheets cell contents.
The other cell , sheet (B135), will contain and only ONE of the three times.
They all work individually but I cant sandwich them into one cell.. Help?
I need to query one cell and display the result on the next tab. I believe my functions are the best for this but I am unable to combine them.
Im working on a separate sheet (Sheet2) with this query
=IF(ISNUMBER(SEARCH("20:00 - 00:00",'Sheet1'!B135)),"NIGHT","")
=IF(ISNUMBER(SEARCH("08:00 - 20:00",'Sheet1'!B135)),"DAY","")
=IF(ISNUMBER(SEARCH("08:00 - 00:00",'Sheet1'!B135)),"24HRS","")
Im asking for a cell to display Day, Night or 24 based on the other sheets cell contents.
The other cell , sheet (B135), will contain and only ONE of the three times.
They all work individually but I cant sandwich them into one cell.. Help?