Question: 4 . In the spreadsheet shown below, we computed profit earned by selling houses by entering the formula = F 8 - E 8 in
In the spreadsheet shown below, we computed profit earned by selling houses by entering the formula FE in cell G and copying it down to G:G 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 G and copied down to G:G to achieve this goal? I. IFERRORFE II ISERRORFE III. IFCOUNTGFE IV IFERRORFE V IFERROREF Just I Just I and II Just III Just I and III Just IV Just I and IV Just I and V
it is the bottom but stuck
Step by Step Solution
There are 3 Steps involved in it
1 Expert Approved Answer
Step: 1 Unlock
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
