Question

you know from working with the loan officer at dollar wise financial services that if a home buyer puts down less than 20% of the homes purchase price, mortgage insurance is required. with 7 - dwmortgageswksht.xlsx open, insert an if statement in the cells in column h that inserts the word no if the percentage in column b is equal to or greater than 20% and inserts the word yes if the percentage in column b is less than 20%. preview, save and then close 7 - dwmortgageswksht.xlsx.

Explanation:

Step1: Understand the IF - statement logic

In Excel, the IF function has the syntax =IF(logical_test, value_if_true, value_if_false). Here, the logical test is whether the value in column B is greater than or equal to 20%. If true, we insert "NO", if false we insert "YES".

Step2: Write the IF - statement formula

In cell H2 (assuming data starts from row 2), the formula would be =IF(B2>=0.2,"NO","YES"). Then we can copy this formula down the cells in column H for all relevant rows in the worksheet.

Step3: Perform file operations

Preview the worksheet to check the results of the IF - statements. Then save the 7 - DWMortgagesWksht.xlsx file and close it.

Answer:

In cell H2, enter =IF(B2>=0.2,"NO","YES") and copy down. Then preview, save and close the 7 - DWMortgagesWksht.xlsx file.