Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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!! |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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!! |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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!! |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Avoiding answer zero by multiply
Note: that will work with blanks, but not 0 values.
Bernie Try this: =PRODUCT(A1,A2,A3) |
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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!! |
#7
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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!! |
#8
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 |
#9
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Calculator Answer Doesn't Match Excel Answer | Excel Discussion (Misc queries) | |||
add value of 4 cells, multiply by 3 subtract 72 multiply by 80% | Excel Discussion (Misc queries) | |||
multiply two numbers and show the answer in a textbox | Excel Discussion (Misc queries) | |||
How do I multiply 1 cell x 1 cell and answer in 3rd cell? | Excel Worksheet Functions | |||
Avoiding #NUM! | Excel Worksheet Functions |