Thread: if formula
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Sande Leonardo Sande Leonardo is offline
external usenet poster
 
Posts: 1
Default if formula

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