Setting default quantities

[Guest]

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.

 

[Biff]

Hi!

You need to use a VBA event change procedure to do this in the same cell. I
can't help you with that.

You could use a helper cell:

A1 = total units

Formula in B1:

=IF(AND(A1>0,A1<6.65),1,A1)

Biff