If a cell value equals zero I want it to be blank. How would I word the formula?
S sarah Feb 26, 2007 #1 If a cell value equals zero I want it to be blank. How would I word the formula?
T T. Valko Feb 26, 2007 #2 Try this: =IF(A1=0,"",do_something_else) If A1 is either empty or contains the number 0 the formula returns a blank. Biff
Try this: =IF(A1=0,"",do_something_else) If A1 is either empty or contains the number 0 the formula returns a blank. Biff
T tim m Feb 26, 2007 #3 You can suppress zeros by going 'tools'....'options'...'view' tab and then uncheck the zero values box. do you just not want to see the zeros or do you actually want to put a blank into the cell?
You can suppress zeros by going 'tools'....'options'...'view' tab and then uncheck the zero values box. do you just not want to see the zeros or do you actually want to put a blank into the cell?
