Recent DiscussionsMost RecentNewest TopicsMost LikesSolutionsTagged:TagRe: IFS function not workingi want this kind of formula. When time is >7=LT <7=P >19=LT <19=P Thanks Re: IFS function not workingI think IFs is not supported on my excel work sheetRe: IFS function not working SergeiBaklan Thanks for your response, but seems the formula was not meet the condition 15:00 #NAME? =_xlfn.IFS( (BG8>7/24)*(BG8<19/24),"LT",TRUE,"P") LT =IF( (BG8>=7/24)*(BG8<=19/24),"LT","P") Re: IFS function not workingHi sir, can you help me with this ifs formula error, =ifs(BG8>"7:00","LT",BG8>"19:00","LT",BG8<"7:00","P",BG8>"19:00","P") Re: IFS function not working SergeiBaklan Hi Sir, can you help me with this ifs error =ifs(BG8>"7:00","LT",BG8>"19:00","LT",BG8<"7:00","P",BG8>"19:00","P") #NAME? 01-Oct 02-Oct 03-Oct Restday Thursday Friday Saturday Monday 6:14 6:12 6:39 Thanks
