Thread: IF Function doesn't recognize TRUE
View Single Post
  #1   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
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