Flag every overdue invoice before collections sweeps the list
Monday AR review is starting. Any invoice more than 30 days outstanding goes to collections; the rest stays 'Current'. Stamp each row so the team doesn't have to eyeball the dates column.
Flag overdue invoices for the AR review
Practice using IF to solve a real finance & accounting problem. By the end, you’ll know when to reach for it and how to structure the arguments correctly.
AR review is at the top of every Monday. The team flags any invoice with days outstanding over 30 as overdue so collections can chase them; everything else stays 'Current'.
In cell E2, return 'OVERDUE' when the days-outstanding in D2 is greater than 30. Otherwise return 'Current'. Drag the formula down through E8 so every invoice on the list is flagged.
IF tests a condition and returns one value if it's true and another if it's false. It's the foundation of every conditional formula in Excel. The condition can use comparison operators (=, <, >, <>), and the two return values can be numbers, text, blanks, or even nested formulas.
IF(logical_test, value_if_true, [value_if_false])Try the formula first. Hints cost CP for a reason.