View Single Post
  #10   Report Post  
TM
 
Posts: n/a
Default

That works like a charm, awesome thanks
--
Tony



"Max" wrote in message
...
"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
--