Thread: if or problem
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
bastien86
 
Posts: n/a
Default 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