I have been trying to have a sheet that mirrors data, I am currently using =sheet1!a1 but if the cell is empty it returns a 0. I have tried the isblank and found that doesn't work. Any advice on how to make sure if it is empty it only returns a blank cell?
One way
=IF(Sheet1!A1="","",Sheet1!A1)
Regards
Special-K
Ensure you describe your problem clearly, I have little time available to solve these problems and do not appreciate numerous changes to them.
That worked awesome. What does the "," actually do? Is that the false statement?
A double set of quotes is the null set. It's not necessarily the same as a blank. If a formula returns the null set ("") then ISBLANK will return FALSE. If a cell is blank however, it will still register true for null set (i.e. IF(A1="", will be True for a blank cell or for a cell containing ""
Hope that helped.
ChemistB
My 2?
substitute commas with semi-colons if your region settings requires
Don't forget to mark threads as "Solved" (Edit First post>Advanced>Change Prefix)
If I helped, Don't forget to add to my reputation (click on the little star at bottom of this post)
Forum Rules: How to use code tags, mark a thread solved, and keep yourself out of trouble
Yes, I have read so many pages and you explained it perfectly!!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks