Question: In cell G 5 , insert a formula using the IF function that tests whether the age of the pledge ( cell F 5 )

In cell G5, insert a formula using the IF function that tests whether the age of the pledge (cell F5) is greater than 21.b. If the age of the pledge is greater than 21, subtract the due date (cell E5) from the current date (cell B2).c. If the age of the pledge is less than or equal to 21, display 0 meaning the pledge is not overdue.d. Use an absolute reference to cell B2 in the formula.e. Use the Fill Handle to fill the range G6:G17 with the formula in cell G5, filling the range without formatting

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Programming Questions!