Prev: Customizing the Display of Data in an Excel Cell
Next: help to reduce size of my file
From: DeeDeeCee on 28 Mar 2010 01:23
I have a spreadsheet that makes some calculation in a column, based on
multiplying numbers entered in 2 other columns. However, for some of the
rows, there is no "input" data, and so the calculation simply indicates the
answer is zero. This gives me a column with lots of zero's in the cells. I'd
prefer there simply to be a blank cell, whenever the result of the formula is
zero. Is there a way to achieve that?

Thanks much.

ddc
From: FSt1 on 28 Mar 2010 02:03
hi
you didn't give enough info to write a proper formula so i'll have to make
one up.

=if(A1+B1=0,"",A1+B1)

or if the formala A1+B1 = 0, display nothing, else desplay the formula
results.

Regards
FSt1

"DeeDeeCee" wrote:

> I have a spreadsheet that makes some calculation in a column, based on
> multiplying numbers entered in 2 other columns. However, for some of the
> rows, there is no "input" data, and so the calculation simply indicates the
> answer is zero. This gives me a column with lots of zero's in the cells. I'd
> prefer there simply to be a blank cell, whenever the result of the formula is
> zero. Is there a way to achieve that?
>
> Thanks much.
>
> ddc
From: מיכאל (מיקי) אבידן on 28 Mar 2010 02:49
If you prefer to hide ALL zeros throughout the WB just de-select the 'zero
values' in the 'Tools' > 'Options' > 'Vies" in order to avoid any formula(s)
modification(s).
Micky


"DeeDeeCee" wrote:

> I have a spreadsheet that makes some calculation in a column, based on
> multiplying numbers entered in 2 other columns. However, for some of the
> rows, there is no "input" data, and so the calculation simply indicates the
> answer is zero. This gives me a column with lots of zero's in the cells. I'd
> prefer there simply to be a blank cell, whenever the result of the formula is
> zero. Is there a way to achieve that?
>
> Thanks much.
>
> ddc
From: מיכאל (מיקי) אבידן on 28 Mar 2010 03:06
Sorry...
This effects every sheet, by itself, which makes it more flexible.
Micky


> If you prefer to hide ALL zeros throughout the WB just de-select the 'zero
> values' in the 'Tools' > 'Options' > 'Vies" in order to avoid any formula(s)
> modification(s).
> Micky
>
>
> "DeeDeeCee" wrote:
>
> > I have a spreadsheet that makes some calculation in a column, based on
> > multiplying numbers entered in 2 other columns. However, for some of the
> > rows, there is no "input" data, and so the calculation simply indicates the
> > answer is zero. This gives me a column with lots of zero's in the cells. I'd
> > prefer there simply to be a blank cell, whenever the result of the formula is
> > zero. Is there a way to achieve that?
> >
> > Thanks much.
> >
> > ddc
From: ozgrid.com on 28 Mar 2010 04:20
Custom Format the cells as: General;-General;
http://www.ozgrid.com/Excel/CustomFormats.htm

Or, Under Excel Options hide zero values.



--
Regards
Dave Hawley
www.ozgrid.com
"DeeDeeCee" <DeeDeeCee(a)discussions.microsoft.com> wrote in message
news:F8CB71B4-CE5C-430C-BAEB-9607E48EFA86(a)microsoft.com...
>I have a spreadsheet that makes some calculation in a column, based on
> multiplying numbers entered in 2 other columns. However, for some of the
> rows, there is no "input" data, and so the calculation simply indicates
> the
> answer is zero. This gives me a column with lots of zero's in the cells.
> I'd
> prefer there simply to be a blank cell, whenever the result of the formula
> is
> zero. Is there a way to achieve that?
>
> Thanks much.
>
> ddc

 |  Next  |  Last
Pages: 1 2
Prev: Customizing the Display of Data in an Excel Cell
Next: help to reduce size of my file