View Single Post
  #1  
Old April 23rd, 2010, 06:27 PM posted to microsoft.public.excel.worksheet.functions
Ryan H[_2_]
external usenet poster
 
Posts: 4
Default Change a cells value with a function

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