formula question

[Guest]

I'm a pretty savvy excel user but am at a loss to how to do this, I'm
embarrassed to say. I have a column of numbers and want to multiply all of
the non-zero numbers. For example, if the column is:

1.056
..9978
..795
0
0
..256

The answer would be .21444430233 (1.056 * .9978 * .795 * .256). I want a
formula that would work for any column of numbers. Thanks for any help.

 

[Jim Rech]

On way:

=PRODUCT(IF(A1:A5=0,1,A1:A5))

Array entered.

--
Jim
| I'm a pretty savvy excel user but am at a loss to how to do this, I'm
| embarrassed to say. I have a column of numbers and want to multiply all
of
| the non-zero numbers. For example, if the column is:
|
| 1.056
| .9978
| .795
| 0
| 0
| .256
|
| The answer would be .21444430233 (1.056 * .9978 * .795 * .256). I want a
| formula that would work for any column of numbers. Thanks for any help.

 

[Tyro]

Assuming your numbers are in A1:A6 use an array formula such as:

=PRODUCT(IF(A1:A6<>0,A1:A6))

Enter the formula with Ctrl+Shift+Enter not just Enter.

Tyro