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
|