To start with, you don't need the SUM() function, as you are not summing but
dividing.
=B2/B3 will do.

What you need is =IF(B2/B3<1,0,B2/B3)
--
David Biddulph

"Sande Leonardo" <Sande wrote in message
...
been going crazy trying to do this

How do I tell one cell do =sum(b2/b3) (this works) for the divide
portion

Now I want to add a formula in with it that tells it, if the number is
less
than 1, put "0", if the number is greater than "0" put that number in.

Anyone know how????