View Single Post
  #9   Report Post  
Max
 
Posts: n/a
Default

"TM" wrote:
....
Can I look to see if both are zero ?


One way ..

We could use in the starting cell:
=IF(OR(A1=0,B1=0),"",A1/B1)

--
Rgds
Max
xl 97
---
Singapore, GMT+8
xdemechanik
http://savefile.com/projects/236895
--