View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Kev
 
Posts: n/a
Default 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.