| 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. |
| 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 | |||
Threaded Mode
