Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Se puede mejorar esta sentencia if
=if(NIVEL_2='mtrCMB','mtrCMB',
if(NIVEL_2='mtrGPO','mtrGPO',
if(NIVEL_2='mtreUSA','mtrUSA')))
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
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
creo que se puede mejorar hasta:
=NIVEL_2
Hi Erich,
The second It's Correct!!