| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Linked cells show wrong number | Links and Linking in Excel | |||
| How do you nest the following formula to show blank cells | Excel Worksheet Functions | |||
| Show cells have been read - linked | Excel Discussion (Misc queries) | |||
| How do you show formulas in certain cells only (not the whole she. | Excel Worksheet Functions | |||
| How do I select cells and make the info populate into a form? | Excel Worksheet Functions | |||
Linear Mode
