if statement in Straight table

[prabunakil]

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.

[andrey_krylov]

if([Total Points Available]<=199, 'Silver',

if([Total Points Available]<599, 'Gold',

if([Total Points Available]>=1000, 'Topaz')))

[Frank_Hartmann]

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!

[prabunakil]

Hi Franky

First two if is working, 

but third if is throw out error '-'.