PATY Currene Matchup.xix Excel Insert Page Layour ort&Find;& Styfes FS Paws Assi

Question

PATY Currene Matchup.xix Excel Insert Page Layour ort&Find;& Styfes FS Paws Assisting Today's Youth Teen-Dog Matchups March 2020 first Name DogID Dog Name Breed Completed Award Eliibility TSO H44- 26Shandian Martin Anna Reggie H Task Instructions Uhura Australian Shephed Enter a formula in cell F4 using the IF function that returns a value of YES cell E4 is greater than 2, and a value of NO if not Greyhound2 oWillam 15 16 Checks whether a condtion is met, and retns one value ifTRUE, and another value VALSE Logital tet sny orexpression that can be evaluated to TRUE or FALSE Matchups ° Ask me anything MacBook Air

Explanation / Answer

I have only data item on which the if statement is to be applied. So the way to write if statement is =if(condition, what to do if true, what to do if false). So in this case for me the equation became as =IF(A1>2,"YES","NO"). You just need to replace A1 by E4 and formula for you becomes =IF(E4>2,"YES","NO"). After that you can use the drag down feature to copy this formula their respective cells.

1 NO 2 NO 4 YES 1 NO 2 NO 1 NO 3 YES 1 NO 3 YES 1 NO

Related Questions

Navigate

• Browse (All)
• Browse P
• Subjects

---

---

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.