SharePoint Stack Exchange is a question and answer site for SharePoint enthusiasts. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

I want to create a column in sharepoint 2010 foundation custom list which functions as the below code

If (Status = "Avail") then -1 ElseIf ((Status = "Apply") then 1 End IF

meaning that when ever while adding an item in the list the new column should have value 1 or -1 according to the option selected in column Status as Apply or Avail respectively.

Is it possible to create such a column

share|improve this question
up vote 5 down vote accepted

You'd want to do something like this:

=IF([Status]="Avail", "-1", "1")

This is a great resource on calculated columns.

share|improve this answer
Great Thanks Very Much It worked! – daveshborasi May 15 '12 at 15:26
Great! Since it resolved your issue, you can click the little check mark to show that. – Eric Alexander May 15 '12 at 15:35

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.