CIS 135 Help with LKE Receivables Excel Mod 8
The past due date is equal to the current date minus the invoice date minus 30; otherwise, it is not
past due and a 0 should be entered in the box. 1. Type the equal sign in Cell G3 by clicking there.
3. Click on Cell B1. Type if (Current Date). Since the cell is named, the absolute is not required.
4. After entering the negative sign, choose Cell B35. Enter ">30" and a comma. 6. Choose
Current Date, click the minus sign, select B3, input a minus sign, 30 and a comma, then click
Current Date. 7. Enter 0 and a pair of parentheses. Red parenthesis should appear at the end. The
ultimate recipe will be =IF(CurrentDate-[@[Invoice Date]]>30,CurrentDate-[@[Invoice
Date]]-30,0)
Put the invoice amount in the cell if Days Past Due is higher than or equal to one AND Days Past
Due is lower than or equal to 30. Put nothing in the cell if it isn't. Thus, an
IF(AND(STATEMENT1 is required. Type =IF(AND(2 in Cell I3 and then click G3 (days past
due). In this case, you will have =IF(AND([@[Days Past Due]] 3. The first parameter in the
AND is of type >=1. Hence, you now click on Days Past Due and write =30), being sure to
include the parentheses as you finish the And function. When concluding the first parameter in
the if function, don't miss the commas.
