Posted to microsoft.public.excel.worksheet.functions
|
|
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
|