Trying to hide a product
 

What I am trying to do is find the product of 2 cells. The first cell is
actually an error because there is no value until I add one to the previous
cells whereas the second cell has a given value of 1. My problem is in the
product cell where I am getting a value of 1 even though the first cell has
an error in it. (eg. cell AX8 (hidden error), AY8 value 1, AZ8 product shown
as 1 but want that hidden until greater than 1 is present. Then the same "1"
shows up at the end BA8 where there is a =SUM formula.

Trying to hide a product
 

I'm not sure if I understand your problem right, but perhaps this
works?

=if(AY8<1,sum(AX8:AY8),"")

- Bas


Confused wrote:
What I am trying to do is find the product of 2 cells. The first cell is
actually an error because there is no value until I add one to the previous
cells whereas the second cell has a given value of 1. My problem is in the
product cell where I am getting a value of 1 even though the first cell has
an error in it. (eg. cell AX8 (hidden error), AY8 value 1, AZ8 product shown
as 1 but want that hidden until greater than 1 is present. Then the same "1"
shows up at the end BA8 where there is a =SUM formula.

Trying to hide a product
 

Actually took a little time after this post to figure out what I had to do.

Thanks for the input..



"Bas" wrote:

I'm not sure if I understand your problem right, but perhaps this
works?

=if(AY8<1,sum(AX8:AY8),"")

- Bas


Confused wrote:
What I am trying to do is find the product of 2 cells. The first cell is
actually an error because there is no value until I add one to the previous
cells whereas the second cell has a given value of 1. My problem is in the
product cell where I am getting a value of 1 even though the first cell has
an error in it. (eg. cell AX8 (hidden error), AY8 value 1, AZ8 product shown
as 1 but want that hidden until greater than 1 is present. Then the same "1"
shows up at the end BA8 where there is a =SUM formula.