How do I assign a value to check box in excel
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<
|