LinkBack URL
About LinkBacks
I have this formula
=(MAX(0,INT(Table7107[@[X]]))
but I want to show blank if its a zero, I try to set the formula to use IF, but not sure how to put it from the tutorial
I have this formula
=(MAX(0,INT(Table7107[@[X]]))
but I want to show blank if its a zero, I try to set the formula to use IF, but not sure how to put it from the tutorial
You could custom-format the cell to suppress display of zero: General;-General;
Entia non sunt multiplicanda sine necessitate
how do I do that? sorry just really a newbie to excel and watched a few tutorials
Select the cell, Home tab, Format > Format Cells, Number tab, select Custom, in the Type: box, paste General;-General; press OK
To hide zeros
Alternatively you can format cell(s) as Custom, 0;;
If you like my answer please click on * Add Reputation
Don't forget to mark threads as "Solved" if your problem has been resolved
"Nothing is so firmly believed as what we least know."
--Michel de Montaigne
Or use this formula :
Please Login or Register to view this content.
I am sure I am doing something wrong, neither way worked.
this is what I do:
I select the entire column, then Select the cell, Home tab, Format > Format Cells, Number tab, select Custom, in the Type: box, paste General;-General; press OK
but still show the 0
What I want to do its to eliminate all the rows that contains 0 in a the columns. (but I saw the tutorial on how to eliminate blanks) so I have to convert it to blank cells. (but I could cut the step and just eliminate rows that have 0
sanram that worked!
Do you have any other conditional formatting on that column? If so then change the number format on those conditional formatting.Originally Posted by chubbychub
And thanks for the rep.
What version of Excel are you using?
Your profile says Excel 2003 but I don't think that table syntax was available in Excel 2003 (I don't have Excel 2003 to test it).
Biff
Microsoft MVP Excel
Keep It Simple Stupid
Let's Go Pens. We Want The Cup.
As far as I know Excel 2003 don't have any Table.
Yeah, they have tables but they're not like the tables in newer versions.
If you're using Excel 2007 or later, try this...
=IFERROR(1/(1/MAX(0,INT(Table7107[@[X]]))),"")
ok, I just changed my profile, I updated 2 days ago and got version of excel 2013.
Tony Valko, that works too.
I am trying to follow this tutorial, but it don't do nothing on my column, not sure what I am doing wrong
https://exceljet.net/tips/how-to-qui...pty-values-win
Good deal. Thanks for the feedback!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks