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