Question: Select cell G 4 and build a formula to subtract the invoice date from the date paid. The first result is 9 5 days.b .

Select cell G4 and build a formula to subtract the invoice date from the date paid. The first result is 95 days.b.Copy the formula to cells G5:7 and note the issue when there is no paid date.C.Undo the copy task.d.Delete the formula in cell G4 and start an IF formula [Logical category].For the Logical test argument, build the subtraction formula (from step 7.a) followed by >=0. The logical test is that the result of the subtraction (the number of days) is greater than or equal to zero, that it is not a negative result.f. CFor the Value_if true argument, show the subtraction formula. When the result of the subtraction is greater than zero, the subtraction is carried out and the result displays.9. For the Value_if false argument, type a space. This displays as an empty cell. When the result is a negative number, the cell displays as blank.h. Copy the formula to cells G5:33 and preserve the borders.

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!