What Excel formulas would I use to calculate the problems below: -

Cell B8 in Summary Sheet is missing the formula to calculate whether or not the total Cost with tax on the Shopping List sheet Cell G5(ScreenShot attached) + the total Cost for purchasing and mailing invitations on the Guest List sheet Cell F6 (Screenshot attached) is greater than the available cash in Summery Sheet Cell B7( Screenshot attached). The cell should display yes or no.

A Sha File Formulas Review View Help Home Insert Page Layout Data . E Insert - 12 - A A Calibri General 5 Delete Conditional Format as Paste Cll Sort & Find & Ideas Sensitiv $ - % 9 58 98 BIU - H Format v Formatting Table Styles v Filter v Select Cells Sensitivi Clipboard Alignment Font Number Styles Editing Ideas fe B8 K. L Party Financing As of 1 1/24/2020 3 # of Invitations 4 58 # of Guests 82 $2,000.00 Cash Available for Event Do We Need to Borrow? Amount to Borrow 10 APR 7.5% # Months to Pay 11 12 12 Monthly Payment Amount| 13 14 15 16 17 10 Places to Shop Summary Guest List Shopping List File Page Layout Formulas Review View Help Home Insert Data Insert v - A A ab v 10 Calibri Currency EX Delete v Paste Conditional Format as Cell So $ - % 9 68 98 BIU v H Format v .00 0 Formatting v Table Styles v Filt Font Clipboard Alignment Number Styles Cells Ed F6 fe =A3*F3+A3*F4 Guest List 82 Total number of guests attending 58 Count of invitations sent 4 Count of missing responses $097 cost per invitation postage cost Total cost for purchasing and mailing invitations $0.56 6 Largest group attending $125.46 1.52 Average number of guests in each group NumAttending Name Tag Title Phone First Name Last Name Street City State Zip 0 Mr. 1 Mrs 2 Miss Cindy Jacobs 417 9th St. Rocklin CINDY JACOBS CA 95602 916-598-6952 CA Grande 87441 Palace Square Newcastle 95602 916-741-8526 Larrina LARRINA GRANDE 4 2068 Harry Hill 87543 Baldys Road 9225 Marchmont Dr Katherine Hairless KATHERINE HAIRLESS Auburn CA 95602 530-888-0805 3 Mr 4 Mr./Mrs 5 Mr/Mrs Muchley James JAMES MUCHLEY Auburn CA 95602 530-885-6523 William Holland WILLIAM HOLLAND 95602 (916)348-9982 95602 (707)521-3478 Saramento CA 2 Bethany Sanchaz BETHANY SANCHAZ 8852 Jones Lane Santa Rosa CA 3 6 Mrs Gerald Watkins GERALD WATKINS 446 Chest Ave 95602 (415)441-8639 95602 (916)315-8690 San Jose CA 7 Mr Thatcher Rocklin Emily 2275 Oak Park Lane EMILY THATCHER CA 3 Mr/Mrs 9 Mr. O Mr. 1 Mr. 852 Paly Place LOUISA CATER Roseville 95602 (916)789-4470 Louisa Cater CA 2 Rocklin Harold Roger HAROLD ROGER 14 Header Dr CA 95602 555-1324 Michael Slocum 543 Tulip Ave Rocklin 95602 555-2453 MICHAEL SLOCUM CA Adam Melon ADAM MELON 387 Daly St Rocklin CA 95602 555-2606 Formulas Help File Review View Home Insert Page Layout Data . AInsert Ac - 10 - A A" ab Calibri Currency EX Delete v Paste Conditional Format as Cell Sor BIU - $ - % 9 58 -98 Format v Formatting Table Styles v Filte Clipboard Font Alignment Number Styles Cells Edi fe 3915.96 G5 A 1 Shopping List 2 number of different items $246 Average item cost 15 $1,500 Highest Item Cost $40 Lowest Item Cost $3,915.96 ITotal Cost with Tax 3 5 Item Description Quantity Units Total Cost City Source CostperUnit Cost Tax 6% 9 Roseville 12 pounds Super Supermarket Sharons Bakery $10.00 $120 Appetizers $7.20 $127.20 $350 10 Folsom 1 Each $350.00 Cake $371.00 $21.00 Dessert Forks, Cofee $50 11 Citrus Heights 12 Citrus Heights The Party Store $0.50 100 each $3.00 $53.00 spoons The Party Store Dessert Plates $1.00 $100 100 each $6.00 $106.00 $125 13 Citrus Heights 14 Citrus Heights 15 Folsom The Party Store $1.25 100 each Dinner Plates $7.50 $132.50 100 sets $1.00 $100 $800 Dinner Silverware $6.00 The Party Store $106.00 $40.00 Flower Power Florist Flower Arangements 20 each $48.00 $848.00 Glass Coffee Cups and 16 Roseville Party Rentals The Party Store $2.00 $100 $150 50 each Saucers $6.00 $106.00 17 Citrus Heights $1.50 Glasses 100 each $9.00 $159.00 A Sha File Formulas Review View Help Home Insert Page Layout Data . E Insert - 12 - A A Calibri General 5 Delete Conditional Format as Paste Cll Sort & Find & Ideas Sensitiv $ - % 9 58 98 BIU - H Format v Formatting Table Styles v Filter v Select Cells Sensitivi Clipboard Alignment Font Number Styles Editing Ideas fe B8 K. L Party Financing As of 1 1/24/2020 3 # of Invitations 4 58 # of Guests 82 $2,000.00 Cash Available for Event Do We Need to Borrow? Amount to Borrow 10 APR 7.5% # Months to Pay 11 12 12 Monthly Payment Amount| 13 14 15 16 17 10 Places to Shop Summary Guest List Shopping List LIBRARY GRADES Moon ping List Places to Shop (+) B. of SCell B8 is missing the formula to calculate whether or not the total cost with tax on the Shopping List sheet + the total cost for purchasing and mailing invitations on the Guest List sheet is greater than the available cCash. The cell should display yes or no. ns sts went ow? yes $2.041.42 7.5% rrow 16.e APR 12 o Pay mount $177.11 $106.00 S100 $150 56 00 59.00 S159 D0