What's wrong?

Posted by Cliff on December 11, 2001 5:20 PM

What's wrong with this formula? The cells I am referring to do have the value 8:00 AM but the formula is still giving me a false.

IF('D:\docs\[LABOR.XLS]Day 1'!$H$32="8:00 AM", "Kerwin", IF('D:\docs\[LABOR.XLS]Day 1'!$H$33="8:00 AM", "Cliff", IF('D:\docs\[LABOR.XLS]Day 1'!$H$34="8:00", "Jamie", IF('D:\docs\[LABOR.XLS]Day 1'!$H$34="8:00 AM", "Adam", "Fonda"))))

Posted by Juan Pablo G. on December 11, 2001 5:45 PM

I think it's a problem with Regional Settings (AM symbol may be A.M. or something different) or Excel is treating 8:00 AM as text. Try with:

IF('D:\docs\[LABOR.XLS]Day 1'!$H$32=1/3, "Kerwin", IF('D:\docs\[LABOR.XLS]Day 1'!$H$33=1/3, "Cliff", IF('D:\docs\[LABOR.XLS]Day 1'!$H$34=1/3, "Jamie", IF('D:\docs\[LABOR.XLS]Day 1'!$H$34=1/3, "Adam", "Fonda"))))

Juan Pablo G.

Posted by Paul Johnson on December 12, 2001 6:31 AM

Another option is to create a cheat column. List your possible times 8:00,8:30,9:00, etc... then reference the the time via the cheat column.

Posted by Cliff on December 12, 2001 9:50 PM

Using 1/3 worked great. Thanks alot!!!!!
Also using the cheat column worked as well.