Thanks Mark W, but still not working
Posted by Cliff on December 18, 2001 8:16 AM
I'm sure I'm not explaining it right. The formulas you have given work great and I thank you for them. Now I have a new problem, can I use several (or) functions in a formula? I have five names that need to be put in a cell based on the contents of a cell. Like =if(or(h32=10:00, h32=11:00), "name", (h33=10:00, h33=11:00), "name", (h34=10:00, h34=11:00), "name", (h35=10:00, h35=11:00), "name"), I have tried this formula but only get####### as a result. I need for the formula above to check h32 to h36 for two to four times and return one of the five names if a cell matches the time.