IF CONDITION

[cosinho89]

Hello everyone,

I need to create this dimension:

=IF([RATING_PUNTEGGIO] <'45', 'INSUFFICIENTE',
IF([RATING_PUNTEGGIO] >'45 and <'70', 'SUFFICIENTE',
IF([RATING_PUNTEGGIO]='70', 'BUONO',
IF([RATING_PUNTEGGIO]>'70', 'OTTIMO'))))

everything works excluding the and operator.

Someone can help me? 

Thanks

Marco

[GaryGiles · Accepted solution]

You need to repeat the field name, like:

=IF([RATING_PUNTEGGIO] <'45', 'INSUFFICIENTE',
IF([RATING_PUNTEGGIO] >'45 and [RATING_PUNTEGGIO] <'70', 'SUFFICIENTE',
IF([RATING_PUNTEGGIO]='70', 'BUONO',
IF([RATING_PUNTEGGIO]>'70', 'OTTIMO'))))