EXCEL 2016 San Diego Sailing Rental and Charter Modal Boat TypeLongth Yaar Soats

Question

EXCEL 2016

San Diego Sailing Rental and Charter Modal Boat TypeLongth Yaar Soats Sloaps Boat ID 1010 Cataina 270 284 20008 1015 Catalina 270 1146 Hunter 33 284200186 33 200410 248 20056 24'8·1200S| 6| 4 24 | 2006| 6 33 2007 10 . 1150 Capri 22 Mk lI 1152 Capri 22 Mk II 1164 Capri 22 MkII 1168 Hunter 33 1175 Bonetaau 40 1180 Beneteau 373 1185 Hunter 36 1190 Beneteau 373 1200 Benotoau 373 1205 Beneteau 40 1225 Hunter 36 1230 Catalina 270 39'10 200812 6 3611200910 6 356 2009 106 36'11 2010 10 3611 2010 106 39'10 20112 356 2012 10 284 2012 6

Explanation / Answer

7.

-->. =IF(G5>7,G5,8); // it means if selected cell G5 is having 8 or more it returns yes else no.

   --> =IF(E1>7,"Yes","No");     //   copy it to next row and drag to remaining rows. it give yes or not                   depends on seat capacity..

-->copy the formula and center the data

8. =TEXT(TODAY(),"mmmm DD , YY")

// if you give mm , then it will give month number , if u give mmm then it gives month name in 3letters , if u give mmmm then it gives full name of month , and remaining format is preceded from ur requirements...

Thank you.....

Related Questions

Navigate

• Browse (All)
• Browse E
• Subjects

---

---

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