Home
> SharePoint > IF and Yes-No Column
IF and Yes-No Column
Today, i’m confronting the IF logical expression with Yes/No column output. For example, i have create a columns name [Acomodation] with output Yes/No options. finally i create another column ( calculated column ) name [Meals]. Here’s the given formula on [Meals]:
- if you’re using Yes/No type column
=IF([Acomodation]=true,1,0) - if you’re using choice type column
=IF([Acomodation]=”yes”,1,0)
Both formula above will give result [Meals]=1 if [Acomodation]=yes. Please Remembered that for Yes/No type column, you can not use “yes”, instead you must use true ( without quotation mark )!
Categories: SharePoint
Comments (0)
Trackbacks (0)
Leave a comment
Trackback
Fransiscus Fendy Novento 