Need help on the formula

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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?
 
Maybe

=PRODUCT(IF(A1:A100>0%,A1:A100,FALSE))

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

Mike
 
Back
Top