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 you’re using choice type column


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

Facebook photo

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

Connecting to %s