IF Function doesn't recognize TRUE

A

AMY Z.

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
 
K

Ken Johnson

AMY said:
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
Click to expand...

Hi Amy,

Try...

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

Ken Johnson
 
D

Dave F

TRUE is a logical operator, not a value in the cell. Therefore, try
eliminating the quotation marks from the TRUE argument in your formula. You
should then get the correct result.

Dave
 
Top