Optimizar o mejorar if

[#1]

Se puede mejorar esta sentencia if

=if(NIVEL_2='mtrCMB','mtrCMB',

if(NIVEL_2='mtrGPO','mtrGPO',

if(NIVEL_2='mtreUSA','mtrUSA')))

[erichshiino · Accepted solution]

Hi,

You can try this

= if( NIVEL_2 = 'mtrCMB' OR NIVEL_2 = 'mtrGPO' or NIVEL_2 = 'mtreUSA' , NIVEL_2)

or

If  mtr is a pattern of the beggining of all the values you want, this can become:

= if( left( NIVEL_2, 3) = 'mtr', NIVEL_2)

Hope this helps,

Erich

[#3]

creo que se puede mejorar hasta:

=NIVEL_2

[#4]

Hi Erich,

The second It's Correct!!