How many of the following formulas could be entered in cell

Reference no: EM13687411

In the spreadsheet shown below, we computed profit earned by selling houses by entering the formula =F9-E9 in cell G9 and copying it down to G10:G1b. 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 G9 and copied down to G10:G12 to achieve this goal?

I. IFERROR(F9-E9,"_ ")
II. ISERROR(F9-E9," _")
III. IF(COUNT(G9)>0,F9-E9,"_")
IV. IFERROR(F9-E9,_)

• V. IFERROR(E9-F9,"_ ")

Reference no: EM13687411

Questions Cloud

Parties to a contract should have and understanding : Parties to a contract should have and understanding of what they are undertaking—a meeting of the minds. Provide an example of two parties who have reached such a clear understanding.

A real estate investment is available at an initial cash out : A real estate investment is available at an initial cash outlay

Why may the corporate bond be preferred : Why may the corporate bond be preferred?

Griswold travel company has issued six-years bonds : Griswold travel company has issued six-years bonds that pay €30 in interest twice each year. The par value of these bonds is €1000 and they offer a yield to maturity of 5.5 per cent. How much are the bonds worth?

How many of the following formulas could be entered in cell : How many of the following formulas could be entered in cell G9 and copied down to G10:G12 to achieve

The pear torte sales are always listed in cell f7 : Suppose you have listed Le Napoleon's monthly sales of pear tortes in a twelve-sheet workbook. The first worksheet contains January sales, the second worksheet February sales, etc. The pear torte sales are always listed in cell F7.

Draw the circular flow model of a simple economy : Draw the Circular Flow Model of a simple economy with the roles of firms, Households, Government and a foreign sector. In addition, identify the factor and product markets in this economy. Identify in the diagram the flows for all injections and leak..

Purchased a zero coupon bond one year ago : Purchased a zero coupon bond one year ago for 109.83. The market interest rate is now 9 percent. If the bond had 25 years to maturity when you originally purchased it, what was your total return for the past year?

Product market-provable supply and demand curve : Consider the product market for 'New York' steaks. Draw the provable supply and demand curve for this product and identify the equilibrium price and quantity. Consider the effect of a 'snafu' in the withholding tax on all consumers in this market whi..

User Account

All Pages