I need to develop a formula to pull three choices from the STATUS column G: Paid, Unpaid, or Overdue. We're currently trying to use the following formula in a nested IF loop:
=IF(ISBLANK(K9),"",IF(K9<TODAY(),"OVERDUE","UNPAID"))
But this only gets us halfway. We need to include an option that IF K9 has a value included (will be a date field, but just needs to identify if a value is there) that this takes precedent and notes column G as 'PAID'. We haven't been able to find a way to make this work thus far.
Any thoughts?