| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Zero values in formula
My formula is A1/A2 however if they are both Zero values it is producing the
#DIV/O! If there are Zeros in A1 and A2 how do I get the product to also be Zero in A3? -- Maggie |
|
#2
|
|||
|
|||
|
Zero values in formula
Maggie,
Try a formula like =IF(A2=0,0,A1/A2) -- Cordially, Chip Pearson Microsoft MVP - Excel Pearson Software Consulting, LLC www.cpearson.com "Maggie" wrote in message ... My formula is A1/A2 however if they are both Zero values it is producing the #DIV/O! If there are Zeros in A1 and A2 how do I get the product to also be Zero in A3? -- Maggie |
|
#3
|
|||
|
|||
|
Zero values in formula
=IF(A2=0,A2,A1/A2)
-- HTH RP (remove nothere from the email address if mailing direct) "Maggie" wrote in message ... My formula is A1/A2 however if they are both Zero values it is producing the #DIV/O! If there are Zeros in A1 and A2 how do I get the product to also be Zero in A3? -- Maggie |
|
#4
|
|||
|
|||
|
Zero values in formula
One way:
=IF(A2,A1/A2,0) -- HTH, RD ============================================== Please keep all correspondence within the Group, so all may benefit! ============================================== "Maggie" wrote in message ... My formula is A1/A2 however if they are both Zero values it is producing the #DIV/O! If there are Zeros in A1 and A2 how do I get the product to also be Zero in A3? -- Maggie |
|
#5
|
|||
|
|||
|
Zero values in formula
CHRIS THANK YOU FOR YOUR RESPONCE HOWEVER, I AM LOOKING FOR THE FOLLOWING.
SORRY FOR THE CONFUSION. A1=1 AND A2=1 AND WHEN I DIVIDE A1 BY A2 THEN IN A3 I GET 1. HOWEVER, WHEN BOTH A1 AND A2 EQUAL ZERO THEN I WOULD LIKE A3 TO EQUAL ZERO. SO THERE STILL NEEDS TO BE A DIVISION CALCULATION BUT WHEN THEY ARE BOTH ZERO IT WOULD THEN BE ZERO IN A3. I HOPE THIS IS MORE CLEAR SOMETIMES I HAVE A HARD TIME GETTING MY POINT ACROSS IN AN E-MAIL. THANKS AGAIN FOR YOUR ASSISTANCE. -- Maggie "Chip Pearson" wrote: Maggie, Try a formula like =IF(A2=0,0,A1/A2) -- Cordially, Chip Pearson Microsoft MVP - Excel Pearson Software Consulting, LLC www.cpearson.com "Maggie" wrote in message ... My formula is A1/A2 however if they are both Zero values it is producing the #DIV/O! If there are Zeros in A1 and A2 how do I get the product to also be Zero in A3? -- Maggie |
|
#6
|
|||
|
|||
|
Zero values in formula
Try
=IF(AND(A1=0,A2=0),0,A1/A2) -- Cordially, Chip Pearson Microsoft MVP - Excel Pearson Software Consulting, LLC www.cpearson.com "Maggie" wrote in message ... CHRIS THANK YOU FOR YOUR RESPONCE HOWEVER, I AM LOOKING FOR THE FOLLOWING. SORRY FOR THE CONFUSION. A1=1 AND A2=1 AND WHEN I DIVIDE A1 BY A2 THEN IN A3 I GET 1. HOWEVER, WHEN BOTH A1 AND A2 EQUAL ZERO THEN I WOULD LIKE A3 TO EQUAL ZERO. SO THERE STILL NEEDS TO BE A DIVISION CALCULATION BUT WHEN THEY ARE BOTH ZERO IT WOULD THEN BE ZERO IN A3. I HOPE THIS IS MORE CLEAR SOMETIMES I HAVE A HARD TIME GETTING MY POINT ACROSS IN AN E-MAIL. THANKS AGAIN FOR YOUR ASSISTANCE. -- Maggie "Chip Pearson" wrote: Maggie, Try a formula like =IF(A2=0,0,A1/A2) -- Cordially, Chip Pearson Microsoft MVP - Excel Pearson Software Consulting, LLC www.cpearson.com "Maggie" wrote in message ... My formula is A1/A2 however if they are both Zero values it is producing the #DIV/O! If there are Zeros in A1 and A2 how do I get the product to also be Zero in A3? -- Maggie |
|
#7
|
|||
|
|||
|
Zero values in formula
Are you saying that you want #DIV/0 if A1 holds 0 and A2 doesn't, because
that is what Chip's alternative will give you. It seems that Chip's original is more robust. -- HTH RP (remove nothere from the email address if mailing direct) "Maggie" wrote in message ... CHRIS THANK YOU FOR YOUR RESPONCE HOWEVER, I AM LOOKING FOR THE FOLLOWING. SORRY FOR THE CONFUSION. A1=1 AND A2=1 AND WHEN I DIVIDE A1 BY A2 THEN IN A3 I GET 1. HOWEVER, WHEN BOTH A1 AND A2 EQUAL ZERO THEN I WOULD LIKE A3 TO EQUAL ZERO. SO THERE STILL NEEDS TO BE A DIVISION CALCULATION BUT WHEN THEY ARE BOTH ZERO IT WOULD THEN BE ZERO IN A3. I HOPE THIS IS MORE CLEAR SOMETIMES I HAVE A HARD TIME GETTING MY POINT ACROSS IN AN E-MAIL. THANKS AGAIN FOR YOUR ASSISTANCE. -- Maggie "Chip Pearson" wrote: Maggie, Try a formula like =IF(A2=0,0,A1/A2) -- Cordially, Chip Pearson Microsoft MVP - Excel Pearson Software Consulting, LLC www.cpearson.com "Maggie" wrote in message ... My formula is A1/A2 however if they are both Zero values it is producing the #DIV/O! If there are Zeros in A1 and A2 how do I get the product to also be Zero in A3? -- Maggie |
|
#8
|
|||
|
|||
|
Zero values in formula
YOU FOR YOUR RESPONCE HOWEVER, I AM LOOKING FOR THE FOLLOWING.
SORRY FOR THE CONFUSION. A1=1 AND A2=1 AND WHEN I DIVIDE A1 BY A2 THEN IN A3 I GET 1. HOWEVER, WHEN BOTH A1 AND A2 EQUAL ZERO THEN I WOULD LIKE A3 TO EQUAL ZERO. SO THERE STILL NEEDS TO BE A DIVISION CALCULATION BUT WHEN THEY ARE BOTH ZERO IT WOULD THEN BE ZERO IN A3. I HOPE THIS IS MORE CLEAR SOMETIMES I HAVE A HARD TIME GETTING MY POINT ACROSS IN AN E-MAIL. THANKS AGAIN FOR YOUR ASSISTANCE. -- Maggie -- Maggie "Bob Phillips" wrote: Are you saying that you want #DIV/0 if A1 holds 0 and A2 doesn't, because that is what Chip's alternative will give you. It seems that Chip's original is more robust. -- HTH RP (remove nothere from the email address if mailing direct) "Maggie" wrote in message ... CHRIS THANK YOU FOR YOUR RESPONCE HOWEVER, I AM LOOKING FOR THE FOLLOWING. SORRY FOR THE CONFUSION. A1=1 AND A2=1 AND WHEN I DIVIDE A1 BY A2 THEN IN A3 I GET 1. HOWEVER, WHEN BOTH A1 AND A2 EQUAL ZERO THEN I WOULD LIKE A3 TO EQUAL ZERO. SO THERE STILL NEEDS TO BE A DIVISION CALCULATION BUT WHEN THEY ARE BOTH ZERO IT WOULD THEN BE ZERO IN A3. I HOPE THIS IS MORE CLEAR SOMETIMES I HAVE A HARD TIME GETTING MY POINT ACROSS IN AN E-MAIL. THANKS AGAIN FOR YOUR ASSISTANCE. -- Maggie "Chip Pearson" wrote: Maggie, Try a formula like =IF(A2=0,0,A1/A2) -- Cordially, Chip Pearson Microsoft MVP - Excel Pearson Software Consulting, LLC www.cpearson.com "Maggie" wrote in message ... My formula is A1/A2 however if they are both Zero values it is producing the #DIV/O! If there are Zeros in A1 and A2 how do I get the product to also be Zero in A3? -- Maggie |
|
#9
|
|||
|
|||
|
Zero values in formula
PLEASE DON'T SHOUT. I READ SENTENCE CASE MUCH BETTER THAN UPPER CASE.
Both of Chip's formulae do what you state. The second will give #DIV/0 if A1 is 0. Tell us what is wrong with what Chip gave you, with what I gave you, what RD gave you. -- HTH RP (remove nothere from the email address if mailing direct) "Maggie" wrote in message ... YOU FOR YOUR RESPONCE HOWEVER, I AM LOOKING FOR THE FOLLOWING. SORRY FOR THE CONFUSION. A1=1 AND A2=1 AND WHEN I DIVIDE A1 BY A2 THEN IN A3 I GET 1. HOWEVER, WHEN BOTH A1 AND A2 EQUAL ZERO THEN I WOULD LIKE A3 TO EQUAL ZERO. SO THERE STILL NEEDS TO BE A DIVISION CALCULATION BUT WHEN THEY ARE BOTH ZERO IT WOULD THEN BE ZERO IN A3. I HOPE THIS IS MORE CLEAR SOMETIMES I HAVE A HARD TIME GETTING MY POINT ACROSS IN AN E-MAIL. THANKS AGAIN FOR YOUR ASSISTANCE. -- Maggie -- Maggie "Bob Phillips" wrote: Are you saying that you want #DIV/0 if A1 holds 0 and A2 doesn't, because that is what Chip's alternative will give you. It seems that Chip's original is more robust. -- HTH RP (remove nothere from the email address if mailing direct) "Maggie" wrote in message ... CHRIS THANK YOU FOR YOUR RESPONCE HOWEVER, I AM LOOKING FOR THE FOLLOWING. SORRY FOR THE CONFUSION. A1=1 AND A2=1 AND WHEN I DIVIDE A1 BY A2 THEN IN A3 I GET 1. HOWEVER, WHEN BOTH A1 AND A2 EQUAL ZERO THEN I WOULD LIKE A3 TO EQUAL ZERO. SO THERE STILL NEEDS TO BE A DIVISION CALCULATION BUT WHEN THEY ARE BOTH ZERO IT WOULD THEN BE ZERO IN A3. I HOPE THIS IS MORE CLEAR SOMETIMES I HAVE A HARD TIME GETTING MY POINT ACROSS IN AN E-MAIL. THANKS AGAIN FOR YOUR ASSISTANCE. -- Maggie "Chip Pearson" wrote: Maggie, Try a formula like =IF(A2=0,0,A1/A2) -- Cordially, Chip Pearson Microsoft MVP - Excel Pearson Software Consulting, LLC www.cpearson.com "Maggie" wrote in message ... My formula is A1/A2 however if they are both Zero values it is producing the #DIV/O! If there are Zeros in A1 and A2 how do I get the product to also be Zero in A3? -- Maggie |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| copy values generated by conditional formula in one sheet to the other work sheet as values | Excel Worksheet Functions | |||
| Formula to make Negative Values Positive & Positive Values Negative? | Excel Discussion (Misc queries) | |||
| FORMULA REQD FOR ADD ING DATES AND VALUES AND PART NUMBERS | Excel Discussion (Misc queries) | |||
| Need formula to check values of data in several cells as criteria | Excel Worksheet Functions | |||
| manipulating formula values | Excel Worksheet Functions | |||
Linear Mode
