Is there a way to check a checkbox or optionbutton if a cell is calculated to
True or False?
--
Cheers,
Ryan


"Tom Hutchins" wrote:

A formula can't edit the value of another cell; it just returns a value to
the cell containing the formula. Try this formula in N74:

=IF(C70="Water Heater",I73=39,I73=99)

I think the answer to your second question is that if the linked cell of
your checkbox contains a formula, like the one above, that returns TRUE or
FALSE, it can be used to control the checkbox - until the first time anyone
checks or unchecks the checkbox directly. Then the formula in the linked cell
will be replaced with TRUE or FALSE.

Hope this helps,

Hutch

"Ryan H" wrote:

Here is my function contained in O74. C70 has "Water Heater" in it and
I73="2". Why doesn't N74 have FALSE in it? Also, is there a way to control
a Forms checkbox with a function?

=IF(C70="Water
Heater",IF(I7339,N74="FALSE",N74="TRUE"),IF(I739 9,N74="FALSE",N74="TRUE"))

--
Cheers,
Ryan