(Answered) In the spreadsheet shown below attached we computed profit

Accounting

In the spreadsheet shown below (attached), we computed profit earned by selling houses by entering the formula =F8-E8 in cell G8 and copying it down to G9:G11. We used the word open to denote a house that is not yet sold. Unfortunately, when a house has not yet been sold our spreadsheet shows the #VALUE error, because you cannot subtract the buy price from the word open. We would like to "error trap" Column G so that when a house has been sold the correct profit has been computed and if the house has not yet been sold a _ will be entered in Column G. How many of the following formulas could be entered in cell G8 and copied down to G9:G11 to achieve this goal?

I. IFERROR(F8-E8,"_ ")

II. ISERROR(F8-E8," _")

III. IF(COUNT(G8)>0,F8-E8,"_")

IV. IFERROR(F8-E8,_)

V. IFERROR(E8-F8,"_ ")

Attachment:- Spreadsheet.jpg

View complete question

Accounting Basics, Accounting

Category:- Accounting Basics
Reference No.:- M91415822
Price:- $10

Verified Expert

Priced at $20 Now at $10, Verified Solution

Have any Question?Write your Review or question?

Related Questions in Accounting Basics

Question - what is the cash flow statement and why is it an

Question - What is the cash flow statement and why is it an important consideration to both the management, investors and creditors?

Question - aztec company sells its product for 160 per unit

Question - Aztec Company sells its product for $160 per unit. Its actual and budgeted sales follow. Units Dollars April (actual) 3,500 $560,000 May (actual) 2,400 $384,000 June (budgeted) 5,000 $800,000 July (budgeted) 4 ...

Question - on january 1 2019 green inc issued stock options

Question - On January 1, 2019, Green Inc. issued stock options for 200,000 shares to a division manager. The options have an estimated fair value of $6 each. To provide additional incentive for managerial achievement, th ...

Question -bella requires 232000 in four years to purchase a

Question - Bella requires $232000 in four years to purchase a new home. What amount must be invested today in an investment that earns 5% interest, compounded annually? Swifty Corporation will receive $21500 today (Janua ...

Question - els an s corporation reported a business loss of

Question - ELS, an S corporation, reported a business loss of $1,000,000. Ethan, ELS's sole shareholder, is involved in ELS's daily business activities and he reports $1,200,000 of taxable income from sources other than ...

Question - lana operates a real estate appraisal service

Question - Lana operates a real estate appraisal service business in a small town serving local lenders. After noting that lenders must pay to bring in a surveyor from out of town, she completes a course and obtains a su ...

Question - santana rey created business solutions on

Question - Santana Rey created Business Solutions on October 1, 2015. The company has been successful, and Santana plans to expand her business. She believes that an additional $86,000 is needed and is investigating thre ...

Question - on december 31 year 1 day co leased a new

Question - On December 31, year 1, Day Co. leased a new machine from Parr with the following pertinent information: Lease term 8 years Annual rental payable at beginning of each year $60,000 Useful life of machine 10 yea ...

Question - bridgeport company had ending inventory at

Question - Bridgeport Company had ending inventory at end-of-year cost of $106,800 at December 31, 2016; $132,696 at December 31, 2017; and $145,140 at December 31, 2018. The year-end price indexes were 100 at 12/31/16, ...

Question - victorias 2016 tax return was due on april 15

Question - Victoria's 2016 tax return was due on April 15, 2017, but she did not file it until June 12, 2017. Victoria did not file an extension. The tax due on the tax return when filed was $9,400. In 2016, Victoria pai ...

4,153,160 Questions Asked
13,132 Experts
2,558,936 Questions Answered

Ask Experts for help!!

Looking for Assignment Help?

Start excelling in your Courses, Get help with Assignment

Write us your full requirement for evaluation and you will receive response within 20 minutes turnaround time.

Ask Now Help with Problems, Get a Best Answer

Recent Questions

Ask Accounting Basics Expert