hide zero

  1. M

    Excel 2010 - If value is zero do not show, show empty cell instead

    Searched Mr.Excel using different wording and this was not easy to find. What I mean is, I did not find the answer here. Used a search engine to find it. In case anyone didn't know the SUPER EASY fix for this, it's under File>Options>Advanced>Display>Display options for this worksheet...
  2. J

    Dynamic 12 month updating line chart to treat zeroes as gap.

    Hello, I have made graphs that update the last 12 months of data on different financial metrics. I have not been able to hide the zero values, as the usual solutions such as the NA() or an IF function that doesn't count the value as it makes the data skip over the cell since it goes back -12...
  3. L

    Display "" without causing #VALUE in next formula

    A1 Date (user entered value) B1 =Text(A1,"ddd") C1 Arrive Time (user entered value) D1 Dept Time (user entered value) E1 =If(IsBlank(C1),"",Mod(D1-C1,1)*24) F1 Afterhours Home Work (user entered value) G1 =E1+F1 Problem: If 'C1' is blank, then value "" placed in E1 -- which causes...

Some videos you may like

This Week's Hot Topics

  • VBA (Userform)
    Hi All, I just would like to know why my code isn't working. Here is my VBA code: [CODE=vba]Private Sub OKButton_Click() Dim i As Integer...
  • List box that changes fill color
    Hello, I have gone through so many pages trying to figure this out. I have a 2020 calendar that depending on the day needs to have a certain...
  • Remove duplicates and retain one. Cross-linked cases
    Hi all I ran out of google keywords to use and still couldn't find a reference how to achieve the results of a single count. It would be great if...
  • VBA Copy and Paste With Duplicates
    Hello All, I'm in need of some input. My VBA skills are sub-par at best. I've assembled this code from basic research and it works but is...
  • Macro
    is it possible for a macro to run if the active cell value is different to the value above it
  • IF DATE and TIME
    I currently use this to check if date has passed but i also need to set a time on it too. Is it possible? [CODE=vba]=IF(B:B>TODAY(),"Not...
Top