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.

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(A10,A1<6.65),1,A1)

Biff

"emerald_dragonfly" wrote in
message ...
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.