View Single Post
  #1   Report Post  
emerald_dragonfly
 
Posts: n/a
Default Setting default quantities

In my spreadsheet I need a cell to default to 1 if the total units entered in
the cell does not exceed 6.64. If the total units enetered does hit 6.65 or
greater than I want that quantity enetered into the cell. Please explain how
to do this.

Thanks so very much.