Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Entries when fields are still blank
Hi
I'm using the following formula for my mail monitoring spreadsheet: =IF(N13<=L13,"Yes",IF(N13L13,"No", IF(J13=No,""))) Column J is the "Response required?" column Column L is the "Target Date" column Column N is the "Actual Response Date" column Column P is the "On target?" column There are only 3 entries on my spreadsheet which were all responded to within target. Therefore there is a "Yes" in column P in all three rows. HOWEVER, the word "Yes" continues all the way down column P even though, as I've said, there are only three entries. Could anyone advise me how to keep column P blank unless there is an entry on the row (without losing the formula!) Sorry for the wordiness of this question. Regards, Adam |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Blank fields | Excel Discussion (Misc queries) | |||
0's in fields that should be blank | Excel Discussion (Misc queries) | |||
How to get pivot table to list duplicate entries in column fields? | Excel Discussion (Misc queries) | |||
Excel 0 and Blank fields. | Excel Discussion (Misc queries) | |||
Excel 0 and Blank fields. | Excel Discussion (Misc queries) |