Cymatic Trader Community

[hedgeupgreen]

Hi,

I'm hoping I'm missing something simple...

I have the following

Code: Select all

=IF(Cymatic!E4="FALSE",1,0)

When Cymatic!E4 shows FALSE this formula returns 0 instead of 1

Likewise, if I alter to read

Code: Select all

=IF(Cymatic!E4="TRUE",1,0)

When Cymatic!E4 shows "TRUE" this returns 0.

I've checked for trailing/leading spaces but cannot identify any issue - I'm probably missing something very stupid, but can anyone see anything wrong?

Ian

[Gavin]

Hi Ian,

Just get rid of the quotes. Write FALSE instead of "FALSE":

Code: Select all

=IF(Cymatic!E4=FALSE,1,0)

Obviously the same applies to TRUE, don't use quotes.

Using quotes turns it into a text (e.g. the word "FALSE"), instead of a Boolean value (TRUE/FALSE).

Kind regards,

Gavin

[hedgeupgreen]

Ah - thanks!