Variable not evaluating

[Anonymous]

Hi everybody

Set vbg7='G'

Set vBG6='R'

If(vbg7 = 'G' and vBG6 <> 'G', vBG6, vbg7)

with above formula I'm still getting 'G' instead of 'R', what mistake I'm making?

Thanking you

[Clever_Anjos]

Getting R, here

[sunny_talwar]

May be share your app

[vvvvvvizard]

If(vbg7 = 'G' and vBG6 <> 'G', 1,2)

Do you get one or two

[vvvvvvizard]

Copy this to script

Set vbg7='G';

Set vBG6='R';

now in textbox add

=If(vbg7 = 'G' and vBG6 <> 'G', vBG6, vbg7) 

[Anonymous]

Hi Guys

I appreciate your help, btw in my case vbg7 needed to evaluate ($(vbg7)) first.

Now works

Thanking you all of you for your valuable time