if or problem
I have the data
0.102365034 9.419 #NUM! #NUM! 0 div/0 I put the formula in: =IF(OR(A1=0,ISERROR(A1)),b0,1/a1-1/2.86) for the column on the right and filled down. How come my 2nd and 3rd lines on the right column aren't 9.419 |
if or problem
Assuming first column is data and second expected result:
for data of #NUM! will fail (error) on the "A1=0" (non-numeric) test while for A1=0, your test returns zero (not div/0). Your test will only work for A1 being a non-zero valid number. (I assume b0 is a typo). Why should they be 9.419? "bastien86" wrote: I have the data 0.102365034 9.419 #NUM! #NUM! 0 div/0 I put the formula in: =IF(OR(A1=0,ISERROR(A1)),b0,1/a1-1/2.86) for the column on the right and filled down. How come my 2nd and 3rd lines on the right column aren't 9.419 |
if or problem
In your formula you are telling it not to do the calculation if it is a 0 or
and error. The question is what is b0? Did you mean for that to be a cell, perhaps B1? "bastien86" wrote: I have the data 0.102365034 9.419 #NUM! #NUM! 0 div/0 I put the formula in: =IF(OR(A1=0,ISERROR(A1)),b0,1/a1-1/2.86) for the column on the right and filled down. How come my 2nd and 3rd lines on the right column aren't 9.419 |
if or problem
its b0 because the i knew that data wouldn't fail and put it at the top, the
data after that would then see if it was either a fail or a 0 in the a column, and if it was return the value above it or do the calculation. "Toppers" wrote: Assuming first column is data and second expected result: for data of #NUM! will fail (error) on the "A1=0" (non-numeric) test while for A1=0, your test returns zero (not div/0). Your test will only work for A1 being a non-zero valid number. (I assume b0 is a typo). Why should they be 9.419? "bastien86" wrote: I have the data 0.102365034 9.419 #NUM! #NUM! 0 div/0 I put the formula in: =IF(OR(A1=0,ISERROR(A1)),b0,1/a1-1/2.86) for the column on the right and filled down. How come my 2nd and 3rd lines on the right column aren't 9.419 |
if or problem
b0 was put in simply to say, if the a column is not 0 or an error then place
the value above the current cell in the cell containing the formula. "Tim M" wrote: In your formula you are telling it not to do the calculation if it is a 0 or and error. The question is what is b0? Did you mean for that to be a cell, perhaps B1? "bastien86" wrote: I have the data 0.102365034 9.419 #NUM! #NUM! 0 div/0 I put the formula in: =IF(OR(A1=0,ISERROR(A1)),b0,1/a1-1/2.86) for the column on the right and filled down. How come my 2nd and 3rd lines on the right column aren't 9.419 |
if or problem
The formula works fine for
=if(iserror(a1),b0,1/a1-1/2.5) but then i have 0 in my a column and it screws up the false part cause 1/0 gives div/0 i want to say iserror or a1=0 but i get problems:\ |
if or problem
How is "bo" defined? Using it, I get a #NAME! error.
"bastien86" wrote: The formula works fine for =if(iserror(a1),b0,1/a1-1/2.5) but then i have 0 in my a column and it screws up the false part cause 1/0 gives div/0 i want to say iserror or a1=0 but i get problems:\ |
if or problem
i figured it out, the #num was screwing up for the test if a2=0, i had to do
=if(iserror(a1),b0,if(a1=0,b0,1/a1-1/2.5)) "Toppers" wrote: How is "bo" defined? Using it, I get a #NAME! error. "bastien86" wrote: The formula works fine for =if(iserror(a1),b0,1/a1-1/2.5) but then i have 0 in my a column and it screws up the false part cause 1/0 gives div/0 i want to say iserror or a1=0 but i get problems:\ |
All times are GMT +1. The time now is 03:06 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com