mercredi 30 mars 2016

Excel: 3 Conditions Issue

Below is an excel formula i created that will result in either of the following:

Weekend, Week Night, or Week Day

If Saturday or Sunday shows in column AL my result is 'Weekend'. If result falls on a Week day (Monday-Friday) between hours of 12a-7:59p the result will be 'Week Day'; and 'Week Night' as my false value.

Below is my fomula:

=IF(OR(AL2="Saturday",AL2="Sunday"),"Weekend",IF(AND(AL2="Monday",AL2="Tuesday",AL2="Wednesday",AL2="Thursday",AL2="Friday",D2>TIME(12,0,0),D2

The Weekend part of the formula works; but all my others result in Week Night

Please help!

Aucun commentaire:

Enregistrer un commentaire