Help with IF function

twdant

I understand how to use the IF function, but I'm having trouble figuring out how to produce the required TRUE value for the first IF argument.

I need a formula that will return a TRUE value if the COPY attribute of a repeating subcomponent is equal to a certain number. Is there a function that will give me a TRUE value if two attributes are equivalent?

Jim

So for an attribute named "Value"

Value: =IF(COPY = 2, TRUE, FALSE)

will return TRUE if COPY i equal to 2 and FALSE otherwise. Have I misunderstood the question?

Jim

There is no == double-equal comparison operator in Dynamic Components. It is just =

Redirecting to http://help.sketchup.com/en/sketchup/dynamic-component-supported-operators

(help.sketchup.com)

(There should be < and <= on the linked page.)

pgarmyn

@jim said:

There is no == double-equal comparison operator in Dynamic Components. It is just =

Redirecting to http://help.sketchup.com/en/sketchup/dynamic-component-supported-operators

(help.sketchup.com)

(There should be < and <= on the linked page.)

Answered too fast, without reading completely.... sorry..

pgarmyn

@jim said:

So for an attribute named "Value"

Value: =IF(COPY = 2, TRUE, FALSE)

will return TRUE if COPY i equal to 2 and FALSE otherwise. Have I misunderstood the question?

Wrong answer :

%(#999999)[Maybee it should be (?):
Value=IF(COPY == 2, TRUE, FALSE)
But this will also work (shorter=better?) :
Value=(COPY == 2)]

Correction : this is for ruby, not for dynamic components

pgarmyn

Wrong answer :
value1==value2 will return TRUE or FALSE

Correction : this was for ruby, not for dynamic components