View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Ryan H Ryan H is offline
external usenet poster
 
Posts: 489
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(I73<39,N74="FALSE",N74="TRUE"),IF(I73<9 9,N74="FALSE",N74="TRUE"))

--
Cheers,
Ryan