Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Getting R, here
May be share your app
If(vbg7 = 'G' and vBG6 <> 'G', 1,2)
Do you get one or two
Copy this to script
Set vbg7='G';
Set vBG6='R';
now in textbox add
=If(vbg7 = 'G' and vBG6 <> 'G', vBG6, vbg7)
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