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

Hi Amy,

Try...

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

Ken Johnson