Thread: IF Function doesn't recognize TRUE
View Single Post
  #6   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 Biff. Nice shortcut.
Amy

"Biff" wrote:

This will also work:

=IF(A1,"Apples","Oranges")

Biff

"AMY Z." wrote in message
...
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