View Single Post
  #6   Report Post  
Posted to microsoft.public.excel.worksheet.functions
RagDyeR RagDyeR is offline
external usenet poster
 
Posts: 3,572
Default Avoiding answer zero by multiply

Sorry!
Product will work with an *empty* cell, not when a cell contains an actual 0
value.
--
Regards,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"Ragdyer" wrote in message
...
Try this:

=PRODUCT(A1,A2,A3)
--
HTH,

RD

--------------------------------------------------------------------------

-
Please keep all correspondence within the NewsGroup, so all may benefit !
--------------------------------------------------------------------------

-
"VenusY" wrote in message
...
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!!