Hi!

Link the checkbox to a cell. The linked cell will return either TRUE for
checked, or FALSE for unchecked.

Then, in the cell where you want the dollar amount entered based on the
checkbox, enter a formula like this:

Assume the linked cell is B1 and the cell for the dollar amount is C1:

Formula in cell C1:

=B1*dollar_amount

When the checkbox is unchecked the result will be 0. When the checkbox is
checked the result will be the dollar_amount.

If you don't want the 0 to be displayed when the checkbox is unchecked then
use this formula:

=IF(B1,B1*dollar_amount,"")

Biff

"
om wrote in message
...
I am creating an order form. I would like to have a check box that when
checked places a pre-determined value (dollar amount) in a cell. Help<