If returning else(false) value even though true conditions match.

[gmbeee]

Hi,

I have an If() statement as follows for the DefaultSelectedItems of a ComboBox:

If(varGroup1=true && varGroup2=false, [“Group1”],[“Group2”])

varGroup1 is 100% true and varGroup2 100% false, yet Group2 is always displayed as the default item.

what am I missing? Thanks.

[CNT · Accepted solution]

@gmbeee Strange! Try revising the formula as,

If(varGroup1 && !varGroup2, [“Group1”],[“Group2”])

[gmbeee]

Perfect! Thank you

[CNT]

@gmbeee Glad the help!