Archive

Archive for February, 2008

Writing Nested IF formula for Calculated Field in Sharepoint 2007

February 22, 2008 21 comments
Some one asked a queston about writing nested IF formula. There was really no documentation available for supported Formulas in Sharepoint Calculated column. I spent some time to answer it to some one and i thought i should share it on my BLOG so it can help others as well.
 
Scenario
A Custom List has a Probability column and a Calculated column was required to show the Probability Status. In this case user only had WSS so they only had the option to use a Calculated formula to Show a String value representing the Status. Requirement was Show a Status based on Probability below is some representation of requirement.
 
0 Never
1-10 Unlikely,
10-40 Possible,
40-70 Likely,
>70 Very Likely,
 
Solution Calculated Formula
Create a Column with type "Calculated (calculation based on other columns) "  and specify the below formula to achive Nested IF based on Probability column value.
 
=IF(Probability=0,"Never",(IF(Probability<10,"Unlikely",IF(Probability<40,"Possible",IF(Probability<70,"Likely","Very Likely")))))
 
Please ask any questions if you have on writing formula.
Advertisements
Categories: Sharepoint 2007

Forums link

February 22, 2008 Leave a comment
SharePoint – Development and Programming
 
Categories: Sharepoint 2007

1st Blog Entry

February 22, 2008 Leave a comment
Hi,
 
I was searching around for a Blog post web site so i can start my blog site. I found that hotmail now does provide the Live Space. It is very exciting news for me. i have couple of Articles that i want to write on my blog post. I will be wrting Article about SharePoint 2007 Custom development different topics. My nick name on News groups is BizWorld.
 
Regards,
 
Moonis Tahir
Senior Software Engineer
MCSD.net, MCTS BizTalk 2006, MCTS SQL Server 2005, MCTS Sharepoint Server 2007
Categories: Uncategorized