Logo 
Search:

Sharepoint Forum

Ask Question   UnAnswered
Home » Forum » Sharepoint       RSS Feeds

Calculated column formula

  Asked By: Varsha    Date: Jan 02    Category: Sharepoint    Views: 1923

I need your expertise to get this working. I have a list that tracks a budget
and uses a calculated column to set the value of the rates for all project
members, using the following formula: =IF([Team Member]="John
Smith","60.64",IF([Team Member]="Jane Smith","62.32",etc.
Now, one of the members has changed his rate and I don't know how to add the
condition: "AND Date > 01/31/2010" to add the new rate.

Can anybody please help me with the right syntax?

Share: 

 

No Answers Found. Be the First, To Post Answer.

 
Didn't find what you were looking for? Find more on Calculated column formula Or get search suggestion and latest updates.




Tagged: