How do I show info only in cells used
IF(X15="paid","",IF((TODAY()-C10)<14, "Overdue", "PAID"))
I have used the formula above to show if an invoice is out of date/unpaid,
however I have dragged the formula down into cells that are currently empty
and they are showing Overdue... How do I make these cells appear blank until
the cells have inf. in them.
|