Book1 – Saving… AutoSave File Home 2 Insert 8 Draw .. Page Layout Formulas Data Review View Help Search Dept. 25 Prolit Report 2 WUID $ $ $ $ $ $ $ 2.68 $ 12.99 $ 10.58 $ 24.99 9.45 $ 20.99 $ 6.78 $ 15.99 $ 6.27 $14.99 $ 18.24 $ 29.99 $ 12.885 31.99 $ 0.24 $ 10.07 0.42 $13.99 1.025 10.52 0.54 $ 3.67 0.38 $ 8.34 1.58 5 10.17 2.24 $ 16.87 22.48% $ 20,000.00 $ 201,400.00 4.02 $75 000.00 $ 1049 250.00 49. 5 12.500.00 $ 131,500.00 45.78% $ 10,000.00 $ 86,700.00 44.36% 515,000.00 $ 125,100.00 66.095 18,000.00 $ 183,060.00 47.265 75,000.00 5 1,265,250.00 $ 225, 500.00 S 3,042,260.00 $ 21.70 5 0.92 $ 11.23 Profit Report Repon Sume Die O Type here to search Caps Lock M Shift ctrk Ctrl 10. Format all dollar amounts with $ signs and 2 decimal places. 11. Format column F with percent sign and 2 decimal places Step B Using Functions – IF()function statement in Excel: 1. Add column title of “If Profit above $140,000” in cell 14 to right of table 2. Use an if() function to return a value of 1 if the projected profit (in column H) is greater than $150,000.00. Make sure that the value 'o' shows up in the column when Projected profit in Column H) is less than or equal to $150,000. 3. Put (or copy) the appropriate IF() in column I for all rows in table, i.e. rows 6 to 12). Option: Once IF() is properly formatted, you may copy the formula to subsequent rows to calculate for all style numbers. 4. In Cell H16, put title of “Count of Styles with Profit above $150,000”. 5. In Cell 116, use the COUNTIF() function to determine the number of styles that have a value of 1 in Column I. 6. Rename the worksheet (tab at bottom) Profit Report Step C Create a new worksheet, name the worksheet (lower tab) Report Summary and also create a title in 1″ row 1. in cell A1, Key the following heading “Ichabod Store Report Summary” as the heading across merged cells of row 1, columns A-Z Make the heading font WHITE on a DARK BLUE background.

"Get 15% discount on your first 3 orders with us"
Use the following coupon
"FIRST15"

Order Now