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. |
How do I show info only in cells used
I am not clear on your rules here. Clearly, If X15 says paid, then there is
nothing to output, but is C10 a due date? If so you will get Overdue when the date is in the future, which seems perverse. This seems a better fit to me =IF(X15="paid","",IF(C10="","",IF(TODAY()<C14,"",I F(TODAY()-C1014, "Overdue", "Due")))) -- HTH RP (remove nothere from the email address if mailing direct) "Kev" wrote in message ... 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. |
All times are GMT +1. The time now is 02:03 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com