ExcelBanter - Need help on the formula

ExcelBanter (https://www.excelbanter.com/)

- Excel Programming (https://www.excelbanter.com/excel-programming/)

- - Need help on the formula (https://www.excelbanter.com/excel-programming/397229-need-help-formula.html)

ddiicc

Need help on the formula

Hi there,
I have a set of datas as shown below :-

A B C D E
0.46% 0.3% 0.15% 0% 0.16%

I would like the formula to do a product of each column but will only do a
product of those % more than 0.

Can anyone help?

Mike H

Need help on the formula

Maybe

=PRODUCT(IF(A1:A1000%,A1:A100,FALSE))

It's an array so enter with Ctrl+Shift+Enter.

Mike

"ddiicc" wrote:

Hi there,
I have a set of datas as shown below :-

A B C D E
0.46% 0.3% 0.15% 0% 0.16%

I would like the formula to do a product of each column but will only do a
product of those % more than 0.

Can anyone help?

All times are GMT +1. The time now is 02:05 PM.