Thread: IF Function doesn't recognize TRUE
View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.worksheet.functions
AMY Z. AMY Z. is offline
external usenet poster
  
Posts: 31
Default IF Function doesn't recognize TRUE
Thanks Ken & Dave.
It fixed it.
Amy

"AMY Z." wrote:

Hi,
Formula is in B1:
=IF(A1="TRUE","Apples","Oranges")

A1 is connected to a CheckBox in a Form.

The problem:
B1 always shows Oranges even if A1 says TRUE.

Thanks for your time,
Amy
Reply With QuoteReply With Quote