Question: a . In cell G 6 , insert a formula using the IF function that tests whether the age of the invoice ( cell F
a In cell G insert a formula using the IF function that tests whether the age of the invoice cell F is greater than
b If the age of the invoice is greater than subtract the due date cell E from the current date cell B
c If the age of the invoice is less than or equal to display to show that the invoice is not overdue.
d Use an absolute reference to cell B in the formula.
e Use the Fill Handle to fill the range G:G with the formula in cell G filling the range without formatting.
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
