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,"_ ")