I want to do a reference to another sheet, but not have it show the 01/01/1900 if there is no data in the other sheet
I want to do a reference to another sheet, but not have it show the 01/01/1900 if there is no data in the other sheet
I believe is empty cell read as 0,suggest you do something like this
=if(B1="","",B1)
-If the problem is solved, please mark your thread as Solved: Click Thread Tools above your first post, select "Mark your thread as Solved".
-Always upload a workbook before start your question
To attach a file, push the button with the paperclip (or scroll down to the Manage Attachments button), browse to the required file, and then push the Upload button.
+++ If my answer(s) helped you, please add me reputation by click on * +++
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks