In the spreadsheet shown below, we computed profit earned by selling houses by e

Question

In the spreadsheet shown below, 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, "_") Just I Just I and II Just III Just l and III Just IV Just I and IV Just I and V

Explanation / Answer

BUY PRICE SELL PRICE PROFIT I II III IV V 400 open #VALUE! _ ISERROR(value) _ #NAME? _ 500 600 100 100 100 100 -100 600 700 100 100 100 100 -100 700 open #VALUE! _ _ #NAME? _ TRUE for first formula condition is satisfied for second formula ISERROR only gives true or false not value so it will not useful for this problem TRUE for third formula it will check if condition then it will give answer. It useful for forth "_" are not mentions so not useful for fifth condition taking reverse so we will get negative sign . So its not useful so the final option just I and III

Related Questions

Navigate

• Browse (All)
• Browse I
• Subjects

---