how to use if statement in a label expression

[#1]

HI,

I am trying to use an expression in a Lable.

Is there any way to use if statement in the lable.

I am trying to read the selected monthname, if the monthname is dec then execute a set of statements else do another.

MonthName is a field from Jan to Dec.

Syntax:

=IF({$<[MonthName]={'Dec'}>},1,2)

How does this work ?

Thanks,

Srihari

[deepakk]

Use the below code

if(MonthName ='Dec' ,1,2)

[#3]

HI Deepak,

that is working fine.

Can this work ?

I want to get 1 when the month is in nov or dec.

Syntax :

If (MonthName='Dec','Nov',1,2)

or

If (MonthName in ('Dec','Nov'),1,2)

Some thing like this ?

Thanks,

Srihari

[Miguel_Angel_Baeyens · Accepted solution]

Hi Srihari,

Use

=If(Match(MonthName, 'Nov', 'Dec') > 0, 1, 2)

That should work.

[#5]

Thank you Baeyens.

Thats working.

Thanks for getting me thorugh Deepak and Baeyens.

Have a nice day !