Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi i write the expression in the straight table:
if([Total Points Available]<=199, 'Silver') and
if([Total Points Available]>=1000, 'Topaz') and
if([Total Points Available]=200 and [Total Points Available]<599, 'Gold')
the value return is = -
which is wrong.
please advise the script which part is wrong.
if([Total Points Available]<=199, 'Silver',
if([Total Points Available]<599, 'Gold',
if([Total Points Available]>=1000, 'Topaz')))
try this:
if([Total Points Available]<=199, 'Silver',
if([Total Points Available]>=1000, 'Topaz',
if([Total Points Available]=200 and [Total Points Available]<599, 'Gold')))
hope this helps!
Hi Franky
First two if is working,
but third if is throw out error '-'.