Clearing 0s in a formula I have a report, which is broken down into three sectio

Question

Clearing 0s in a formula

I have a report, which is broken down into three sections, that collects data for the entire month. One column is always the same, regardless of which section it is, they are always the same.

Currently I have it so in the second section the cell just looks above to whatever value it is, and mirrors it. Same for the third section. The problem is, if I drag the formula for the month, until the data is actually entered, there are all these "0"s.

Is there a way to hide them?

Thanks!

Explanation / Answer

SS As there w2as no actu7al posted answer, here are a couple of options.

    use a custom number format of General;General;;General
    Go to File, Options, Advanced, Display options for this worksheet and uncheck Show a zero in cells that have zero values
    Use an IF() function to show only non-zero values, providing an empty string if zero. Example:
        =IF(<formula>,<formula>,"")

Related Questions

Navigate

• Browse (All)
• Browse C
• Subjects

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.