Ravi Sir's Cards › Excel
Guest List and Budget in Excel (card 1 of 2)
Revision card 1 for Guest List and Budget in Excel: Expected guests from the RSVP: =IF(D5="Yes",C5,IF(D5="Maybe",ROUND(C5*0.5,0),0)) gives 12; Total expected: =SUM(E5:E12) gives 57. Includes an example data table.
Read card text
What this card says
1 for Guest List and Budget in Excel: Expected guests from the RSVP: =IF(D5="Yes",C5,IF(D5="Maybe",ROUND(C5*0.5,0),0)) gives 12
Total expected: =SUM(E5:E12) gives 57. Includes an
Example
data table
Learn this in the lesson: Guest List and Budget in Excel for a Function: RSVP Count, Plates to Order and Total Cost