Formulas are getting too complicated

[Guest]

Good day. I am using Excel 2002 and consider myself an above average user.
I have a worksheet that computes my pricing for my store based on the
products used to create an item for sale. There are close to 100 items that
use a standard product price worksheet.

There are several places in each of the worksheets where no values may be
necessary. To keep these cells from showing a zero amount or a zero
quantity, I have included the following preface to most of the cell formulas;

Cell G6 contains the formula = IF C6="","",E6*F6

The formula above looks at cell C6 and if there is no entry in that cell,
then I want no value to be shown in cell G6.

Is there a way to format the entire worksheet to prevent zero values from
showing? Or is there a better way to accomplish my goal?

Thanks in advance to those who answer, Danno...

 

[kk]

Hi Danno

Try...

Tools | Options | View | Window Options | uncheck Zero Values


Good day. I am using Excel 2002 and consider myself an above average user.
I have a worksheet that computes my pricing for my store based on the
products used to create an item for sale. There are close to 100 items that
use a standard product price worksheet.

There are several places in each of the worksheets where no values may be
necessary. To keep these cells from showing a zero amount or a zero
quantity, I have included the following preface to most of the cell
formulas;

Cell G6 contains the formula = IF C6="","",E6*F6

The formula above looks at cell C6 and if there is no entry in that cell,
then I want no value to be shown in cell G6.

Is there a way to format the entire worksheet to prevent zero values from
showing? Or is there a better way to accomplish my goal?

Thanks in advance to those who answer, Danno...

 

[William]

Hi

Try formatting the relevant cells with the following...

[>0]#,##0_ ;[Red][<0](#,##0);
--


XL2003
Regards

William
(e-mail address removed)

 

[Guest]

Thank you for the quick response. Your answer to my problem is not one that
I would have thought of. I will give it a try. Thanks, Danno...

Hi

Try formatting the relevant cells with the following...

[>0]#,##0_ ;[Red][<0](#,##0);
--


XL2003
Regards

William
(e-mail address removed)

Good day. I am using Excel 2002 and consider myself an above average
user.
I have a worksheet that computes my pricing for my store based on the
products used to create an item for sale. There are close to 100 items
that
use a standard product price worksheet.

There are several places in each of the worksheets where no values may be
necessary. To keep these cells from showing a zero amount or a zero
quantity, I have included the following preface to most of the cell
formulas;

Cell G6 contains the formula = IF C6="","",E6*F6

The formula above looks at cell C6 and if there is no entry in that cell,
then I want no value to be shown in cell G6.

Is there a way to format the entire worksheet to prevent zero values from
showing? Or is there a better way to accomplish my goal?

Thanks in advance to those who answer, Danno...

 

[Guest]

Thank you for the quick response to my problem. I knew there had to be a
simple answer to this issue. I will experiment with this. Thanks, Danno...