zero cell

Hi Guys, I'm trying to create a macro where cell that has "0" value will be separated. <tbody> Code Name Score 1 Score 2 Score 3 Score 4 Score 5 Score 6 01 John 98 98 95 95 93 90 02 Ben 96 97 94 93 93 90 03 Sean 0 0 0 0 0 0 04 Carl 90 0 90 0 89 0 05 Tim 0 0 0 0 0 0 </tbody> End...

Greetings all - I have looked high and low and can see that a lot of people have asked about how to keep a line chart from plotting blank cells, but I seem not to be able to nail it down in any effective manner. I have a column that is 25k rows. Each cell has a formula that produces a...

I'm using ceiling.math to roundup value to nearest 25, but it will not adjust a value of 0 upwards. How do I do this? I don't want any value less than 25.

I have three sheets a budget, actuals , and then a performance sheet (the difference between what we budgeted and what we spent). Each are divided by months and expenses. The equation is =SUM(Budget:Actuals!B6). I want to make it so cells in the performance sheet don't populate if there is a...

Hello, Let's say I have two primary columns in my spreadsheet, x and y. Depending on what I want to do with the data, zeroes need to be handled differently. Currently, I have three cases. This results in me needing additional 'dummy' columns that duplicate the data except for how zeroes are...

Hi all! So I am trying to track goals vs ytd using percentages. At first I was using equation YTD/GOALS, however that was not working when either goals or ytd equaled to zero. Then I tried using =IF(G5=0,1,H5/G5), but it wasn't given me the correct results (on the 4th number on the graph it...

Hi, I would really appreciate it if someone could help me please. I've written an IF statement where I want the values to return true if all selected cells equal to zero and false if equal to anything else. The values are rounded to 2 decimal places. However, from 7 decimal places onwards it...

Hi Team, I'm facing lot of issues with my "zero" value cells.... I have one protected master data sheet where will just copy and paste the values. I will work on another file where I will do lot of formatting and functions. The problem is whenever I copy paste the zero values for example...

hi all , i have and excel sheet which is a compilation of various sheets copied from different sources . i want to delete the rows where their cells in column e equals zero starting from e3 as e2 has a zero value i want to keep. the sheet that contains that column is named "all data" thanks a...