Hi Guys!
Good Day to all.
Need some help here.
Is it possible to show ZERO (0) values on a certain cells only if i turn off the (Show a zero in cell that have zero value)? Because if i turn on that it will ruin my worksheet.
Thanks!
Hi Guys!
Good Day to all.
Need some help here.
Is it possible to show ZERO (0) values on a certain cells only if i turn off the (Show a zero in cell that have zero value)? Because if i turn on that it will ruin my worksheet.
Thanks!
If the "certain cells" have formulas, you can show or hide zeros by wrapping your formula in an IF function...
Hide zeros in cells with formulas
=IF(Your_Formula = 0, "", Your_Formula)
Or if you have the option Show Zeros turned off, this will show a text-zero in a formula cell.
=IF(Your_Formula = 0, "0", Your_Formula)
Surround your VBA code with CODE tags e.g.;
[CODE]your VBA code here[/CODE]
The # button in the forum editor will apply CODE tags around your selected text.
Hi,
I was thinking something like AlphaFrog above but tie your formula to a Cell like A1. If A1 = 0 then show zeros and if A1 = 1 then make those zeros a blank.
=if(A1=0, your formulas answer = 0, your formulas answer = "")
One test is worth a thousand opinions.
Click the * Add Reputation below to say thanks.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks