View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
puting_uwak puting_uwak is offline
external usenet poster
 
Posts: 1
Default Formula Help Needed

Help please!

I have this formula in cell I31:

=IF(AND((OR(E31="Pipe",E31="Riser")),(NOT(H31=0))) ,"m",IF(AND((H311),(NOT(E31=""))),"nos.",IF(AND(( H31=1),(NOT(E31=""))),"no.","")))

The problem is that I31 still returns "nos." if E31 has text and H31 is
blank. I31 should be blank if E31 contains text and H31 is either blank or
zero.