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

IF Function doesn't recognize TRUE
 

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

IF Function doesn't recognize TRUE
 

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
--
Brevity is the soul of wit.


"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

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

IF Function doesn't recognize TRUE
 

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

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

IF Function doesn't recognize TRUE
 

You're welcome!

Biff

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