In my current workbook I have a lookup function that looks up dates in other Excel files:
However, the function is returning a date value of 00-Jan-00 whenever no date is found against the lookup value in A2.
Please Login or Register to view this content.
The cell should be left blank if that's the case and not display 00-Jan-00.
Can anyone recommend how that can be achieved?
Last edited by SpiritedAway; 08-23-2013 at 08:32 AM.
You would normally do this:
=IF(your_formula=0,"",your_formula)
but that would make it a bit unwieldy. Another way is to apply conditional formatting to the cell, such that if the cell is zero use the same foreground colour as background, so that it would appear blank.
Hope this helps.
Pete
Hi,
Can you please upload a sample of your workbook containing the formula with the erroneous result so that I can step through the calculation to see why this is happening?
Thanks
Try custom formatting the formula cell as follows:
dd-mmm-yy;;
the two semi-colons at the end ensure that zeroes are shown as blanks rather than 00-Jan-00
Audere est facere
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks