function IF

[roger0802]

Hi to everybody,

Maybe it's a sample question..

is it possible to make a function IF with text, NOT number?

or is there something similar?

example:

if([namefield]=N,a,b)

THANK YOU VERY MUCH!

Ruggero

[MK_QSL]

if([namefield]='N','a','b') as [namefield]

[#3 · Accepted solution]

Hi,

Just use the quotation marks to identify the text field.

Ex:- if([namefield]=' N ',a,b)

See the 'N' in your expression.

Priyantha.

[nikhilgarg]

Hey,

But i think if([namefield]='N','a','b') as [namefield] will also work fine. Isn't it ?

[buzzy996]

u have to try like this,

if([namefield]='N','a','b')

[#6]

Hi,

not only number text also can work

Ex:

    =if([namefield]='N','a','b') as [namefield])

here, N means some text

[tcullinane]

use

if(match([namefield],'N'),'a','b') as [namefield]

match, wildmatch etc are handy for text.

[roger0802]

Really thank you to everybody!

Ruggero

[Anonymous]

Could you please close this thread by marking the correct answer?  And maybe helpful answers as well?

It will give the deserved points to the "answerers", and will help those who use search.

[roger0802]

You're right..