create formula

E G Q 3 Task 2 of 10 Assignment: Training: Analyzing D... Task: EX8872 Create a formula usi... Guide ? S Search M Apply Submit + Ask new AutoSave . Off H Rockland Clients.xIsx - Excel Sign in X File Home Insert Page Layout Formulas Data Review View Tell me what you want to do Shar 3. Translate the Logic into an Excel Formula: Calibri 11 - A" A % . To perform these operations without parentheses, the formula will look Paste BIU - - -A- Alignment Number Conditional Format as Cell Cells Editing like this: Formatting * Table Styles Clipboard Font Styles = C4 + (C4 * E4) - F4 D5 X v fx 11 A B C Formula Bar E F G H J K 4. Enter the Formula in Cell G4: Years as 4 Client ID Company Name Sales to Date Client . Click on cell G4. 101 EnergyPro $ 1,530,750 11 $ 1,420,500 LO . Type in the formula: 102 Aster Communications 103 Merritt Hospitals $ 1,398,000 =C4+C4*E4-F4 104 Grande Insurance $ 1,175,000 105 Armaza Biotech $ 1,053,000 5. Press Enter: 10 106 RELICO 997,000 11 107 Malloys 860,000 . After inputting the formula, press Enter to see the calculated projected 12 108 Carter Healthcare 755,000 salary. 13 744,500 H H N N W A U O V VD 109 AM Pharmaceuticals 14 110 Consolidated Goods 689,000 Final Formula in G4 15 111 Tye Automotive 704,000 16 698,800 The complete formula you should enter in cell G4 is: 112 Wind Power Association 17 113 SC Logistics 445,200 =C4+C4*E4-F4 18 114 UniComm 375,600 By following these steps, you'll successfully calculate the "Projected 2021 19 Total Clients 20 21 22 Ask Al your follow up question. Do not enter personal information. 23 24 25 Task Instructions X 26 In cell D19, create a formula using the COUNT function to Project Sales + Image Document count the number of values in the range D5:D18. Ready e 11:55 PM O Type here to search 3/25/2020