I Need only the equation for the Half Day column. You can look at the example so
ID: 3667013 • Letter: I
Question
I Need only the equation for the Half Day column. You can look at the example so you can see if your work is right or wrong on the sheet on Half Day column. I'm done with everything else.6 Screen Shot 2016-02-10 at 8.25.16 PM Q Search Weather Condition Temperatures Snow accumulation (inch) Wind (MPH) Snow Day (Y/N) Half Day (Y/N) Monday Tuesda Wednesday Thursday Friday Monday Tuesday Wednesday Thursday 6.5 5.5 5.5 6.1 2.5 4.3 16 20 16 25 12 25 25 14 6.1 2.5 6.5 25 16 I need only Half Day equation. I'm done with everything else 6.1 2.5 6.5 5.5 25 Tuesday Wednesday Thursday Friday 16 12
Explanation / Answer
=IF(AND((B1<10),(C1>5),(D1>15)),"N","Y")
=IF(AND((B1<10),(C1>5),(D1>15),(E1="Y")),"N","Y")
Related Questions
Navigate
Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.