How do I keep a cell blank if it is equal to 0?
How do I keep a cell blank if it is equal to 0?
On the main menu, select Tools>Options. On the View tab, uncheck 'Zero Values', click OK.
HTH
Bruce
Bruce
The older I get, the better I used to be.
USA
How do I only designate a column with blank zero values? It did the whole sheet.
Sorry, you didn't specify to limit it to an area.
You will need to recheck the 'zero values' box in Options, then modify your formulas.
The new formula would look like this:
=IF(<yourcurrentformula>=0,"",<yourcurrentformula>)
HTH
Bruce
I currently have this formula ,=IF(H2>8,H2-8,0), in that cell. How do I also implement the other formula together?
like this:
=IF(H2>8,H2-8,"")
Simple?
Thank you very much for your help!!!
No problem. Glad it worked out for you. Thanks for the feedback.
Cheers!
Bruce
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks