Glenn and Diane want to be able to view their monthly cash flow under both mortgage

possibilities. The mortgage being applied to the

budget will be determined by whether 1 or 2

is entered into cell C3. To switch from one mortgage to another, do the

following:

In cell C25, enter an

IF

function that tests whether cell C3 equals 1, if it does, display the

value from cell J11; otherwise, d

isplay the value from cell N11 (use absolute cell

references in the

formula).

Use AutoFill to copy the formula in cell C25 into the range

D25:N25.

Verify that the values in the range C25:N25 match the monthly payment for the

first

mortgage

condition.

LINK: https://www.coursehero.com/file/p6k4hide/13-Glenn-and-Diane-want-to-maintain-an-average-net-cash-flow-of-at-least-1200/