Anyone willing to help
Posted by cliff on December 12, 2001 10:03 PM
I'm trying to write a formula to check the time in a cell. I have already used up 4 of my limited 7 IF functions but I want the formula to be able to test for 7 different times. I can't write 7 IF functions because I 5 different values to return if a time is found. The formula I have works great(thanks to this message board) for returning a value based on one time. I have tried using
OR(1/3,10/24,11/24,14/24,15/24,16/24,17/24) nested in my IF function, I don't get a formula error but I don't get a return of TRUE either. The formula I am using is IF($h$32=or(1/3,10/24,11/24,14/24,15/24,16/24,17/24), "Name", "")
Am I just writing it incorrectly or using the wrong function?
Posted by Steven on December 12, 2001 11:27 PM
Hi Cliff,
Maybe this forumla can help you:
=IF((OR(H32=1/3,H32=10/24,H32=11/24,H32=14/24)), "Name", "")
If you type in one of the values indicated (e.g.=1/3) it should generate the string Name.
Hope it helps.
Steven
Posted by Mark W. on December 13, 2001 2:26 PM
Another formulation...
=IF(OR($H$32={8,10,11,14,15,16,17}/24),"Name","")
