LinkBack URL
About LinkBacks
In Excel 2010, which I have now, I end up with a sheet full of zeros, that I then have to delete one by one. Does anyone know how to make it so a cell containing a formula referencing an empty cell will look empty/blank?
Thanks so much
In Excel 2010, which I have now, I end up with a sheet full of zeros, that I then have to delete one by one. Does anyone know how to make it so a cell containing a formula referencing an empty cell will look empty/blank?
Thanks so much
Please Login or Register to view this content.
your formula will be 0 becuase some part of the equation is blank... if you can reference that cell you can use something like this...
pretend... A1 = blank, B1 = blank... and cell C1 contains the formula =a1+b1 which will return a zero.
If you add to the formula =if(a1+b1=0,"",a1+b1) that will return the results if there is one, or be blank if there is not.
Does this help?
Last edited by Legend Rubber; 08-20-2014 at 01:08 PM. Reason: my mistake...
Or, you can go into Options / Advanced and switch off the option to show zeros in cells.
Not ideal as sometimes you want to show them, but it's a suitable option sometimes and negates the need to double up your formulas as per the suggestions above.
BSB.
thank you folks
control F type 0 select option tick match entire cell contents replace all
unfortunately that still finds cells which are referencing a cell containing the value zero as well as blanks but this seems to be the best answer so far so thanks
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks