Today’s function is CHRISTMAS_JUMPER_DECIDER. Lets you know if you should or should not wear a Christmas Jumper on any given day.
=LAMBDA(date,singing_carols,christms_party,casual_dress_permitted,
IF(OR(singing_carols, christms_party * casual_dress_permitted, (DAY(date) >= 22) * (MONTH(date) = 12), (DAY(date) >= 12) * (MONTH(date) = 12) * casual_dress_permitted),
"Christmas Jumper? Go for it!", "Christmas Jumper? Maybe not a great choice."))
ليست هناك تعليقات:
إرسال تعليق