View Single Post
  #2  
Old April 23rd, 2010, 07:39 PM posted to microsoft.public.excel.worksheet.functions
Tom Hutchins
external usenet poster
 
Posts: 722
Default Change a cells value with a function

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