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 )!

Advertisements
Categories: SharePoint
  1. No comments yet.
  1. No trackbacks yet.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s