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 G and build a formula to subtract the invoice date from the date paid. The first result is days.bCopy the formula to cells G: and note the issue when there is no paid date.CUndo the copy task.dDelete the formula in cell G and start an IF formula Logical categoryFor the Logical test argument, build the subtraction formula from step a followed by 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 Valueif 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 For the Valueif 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 G: and preserve the borders.
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
