=IF(B2/B3<1,"0",B2/B3) should do the trick. I'm not sure why you had SUM in
your original forumla as it doesn't do anything, you just need to tell it to
divide the cells =b2/b3

"Sande Leonardo" wrote:

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????