Question

ML INFL.com - Official Site of th Dallas CowboysOfficial Graw Hill Canned Deep McGraw Hill Come Deep 03 Ad Learning GN X https://newconnecteducation.com low correcthtml h 3 Adl Learning - GM and Excel is calls dining Paster mood Number - Condtonal Forrest an cat Forg Tle Styles Styles 0 2. Use the Excel IF function to label cell ASI as either "Net Income" or "Netloss" as 31 appropriate based on the value calculated in cell 51. Sales Discount 4,700 References NOODLES UNLIMITED, INC 31 income Statement for the Year Ended December 31, 20X1 36 Sales Revenue $125.500 37 Less: 6.000 » Sales Returns and Allowances 40 Net Sales 164,800 41 Cost of Goods Sold 67,700 42 Gross Margin 97.100 43 Expenses: Salaries and Wages Expense 25,900 45 Rent Expense 46 Utility Expense 13 47 Income from Operations 33,400 Interest Expense 1.600 49 Income before Income Tax Expense 31,800 50 Income Tax Expense 7,700 51 =1F 52 Flogical test volueruelvake it belo Come the main pronta . ) - Sheet1 READY Attempts 10/10 < Prev 2 of 2 Next > Search the web and your PC

Answer 1

Formula to be entered in cell A51:-

=IF(B51>=0,"Net Income","Net Loss")

IF x x =IF(851>=0,"Net Income", "Net Loss") A 175500 6000 4700 164800 67700 97100 36 Sales Rev 37 Less 38 Sales Dis 39 Sales Return & Allowance 40 Net Sales 41 COGS 42 Gross Margin 43 Expenses:- 44 Salaries 45 Rent Expenses 46 Utilty Expenses 47 Income from Operations 48 Interest Expeses 49 Income before Tax 50 Income Tax 51 Income","Net Loss") 25900 24000 13800 33400 1600 31800 7700 24100