Maybe something like this then,
in A3: ="1:"&ROUND(A2/A1,-3)
Adapt to suit
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:27,000 Files:200 Subscribers:70
xdemechanik
---
"Matt" wrote:
What I have is we processed 463000 pieces and we had 163 errors so i need
cell A3 to show the ratio like 1/5000