Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Balance Sheet December 31, 20XX Assets: Liabilities: Cash $32,000 Salaries payable $12,000 Accounts receivable 29,000 Notes payable 30,000 Supplies 16,000 Service revenue Land 75,000 Stockholders'

Balance Sheet December 31, 20XX Assets: Liabilities: Cash $32,000 Salaries payable $12,000 Accounts receivable 29,000 Notes payable 30,000 Supplies 16,000 Service revenue Land 75,000 Stockholders' Equity: Common stock 62,000 Retained earnings 48,000 Total assets $152,000 Total liabilities and stockholders' equity $152,000

3. Use a conditional statement to evaluate whether the accounting equation balances. (Construct a conditional IF statement to return the word "equal" if the balance sheet is in balance or "not equal" if it is not. In your formula, use cell B49 for total assets and D49 for total liabilities and stockholders' equity.) Total Assets 152000 Total Liabilities + Total Stockholders' Equity

I just need the IF statement written out in an excel sheet format please.

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access with AI-Powered Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Students also viewed these Accounting questions