Avoiding answer zero by multiply
 

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!!

Avoiding answer zero by multiply
 

VenusY;372051 Wrote:
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!!

Do you mean that your answer should not display 0 ?
Thyen try =if(a1*a2*a3=0,"",a1*a2*a3)


--
Pecoflyer

Cheers -
------------------------------------------------------------------------
Pecoflyer's Profile: http://www.thecodecage.com/forumz/member.php?userid=14
View this thread: http://www.thecodecage.com/forumz/sh...d.php?t=104171

Avoiding answer zero by multiply
 

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!!

Avoiding answer zero by multiply
 

Venus,

Array enter (enter using Ctrl-Shift-Enter)

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

HTH,
Bernie
MS Excel MVP


"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!!

Avoiding answer zero by multiply
 

Note: that will work with blanks, but not 0 values.

Bernie


Try this:

=PRODUCT(A1,A2,A3)

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!!

Avoiding answer zero by multiply
 

Bernie,
Nope, this cant help me up.
the answer still showed zero instead of 6 (A1*A2).

"Bernie Deitrick" wrote:

Venus,

Array enter (enter using Ctrl-Shift-Enter)

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

HTH,
Bernie
MS Excel MVP


"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!!

Avoiding answer zero by multiply
 

Hi Pecoflyer,
Yes, i dont want answer show me zero or blank, only show me 6 (A1*A2).

"Pecoflyer" wrote:


VenusY;372051 Wrote:
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!!

Do you mean that your answer should not display 0 ?
Thyen try =if(a1*a2*a3=0,"",a1*a2*a3)


--
Pecoflyer

Cheers -
------------------------------------------------------------------------
Pecoflyer's Profile: http://www.thecodecage.com/forumz/member.php?userid=14
View this thread: http://www.thecodecage.com/forumz/sh...d.php?t=104171

Avoiding answer zero by multiply
 

Hi,
Bernie's formula works for me.
Did you enter the formula with Ctrl+Shift+Enter as recommended ?

venusy;372346 Wrote:
Bernie,
Nope, this cant help me up.
the answer still showed zero instead of 6 (A1*A2).

"Bernie Deitrick" wrote:

Venus,

Array enter (enter using Ctrl-Shift-Enter)

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

HTH,
Bernie
MS Excel MVP


"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!!





--
Pecoflyer

Cheers -
------------------------------------------------------------------------
Pecoflyer's Profile: http://www.thecodecage.com/forumz/member.php?userid=14
View this thread: http://www.thecodecage.com/forumz/sh...d.php?t=104171