Maybe something like this...

=MAX(0,ROUND(A1/A2,1))

--
Biff
Microsoft Excel MVP


"mike" wrote in message
...
I have an excell spread sheet and i am dividing two cells. Most of the
numbers are positve but some of the numbers are negative. I want to put a
formula in to all the cells that will divide the two cells and give me the
answer to one digit but if the number is negative i want it to display as
0.