Avoiding answer zero by multiply

  • Thread starter Thread starter VenusY
  • Start date Start date
V

VenusY

Hi,
Please help me to solve my problem:

A1*A2*A3=A4

If the number for
A1=2,
A2=3,
A3=0,
then A4 answer will be zero.
How can i calculate it out with above formulation (A1*A2*A3=A4) by not
giving me the answer zero?

Thanks!!
 
Venus,

Array enter (enter using Ctrl-Shift-Enter)

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

HTH,
Bernie
MS Excel MVP
 
Bernie,
Nope, this cant help me up.
the answer still showed zero instead of 6 (A1*A2).
 
Back
Top