If Column1 = East then Column5 = John Smith. If Column1 = West then Column5
= Roger Brown. If Column1 = North then Column5 = Jack Tate. If Column1 =
South then Column5 = Jim Black.
I looked all over SharePoint help and it doesn't appear this particular
formula is a feature of SharePoint, but I just want to double check. Any
idea? Thanks.
erik
IF(logical_test,value_if_true,value_if_false)
You can get to this in the online help by at
http://[servername]/_vti_bin/help/1033/sts/html/lif4.htm. For instance,
here's one currently available online:
http://usa1021.wss.bcentral.com/_vti_bin/help/1033/sts/html/lif4.htm. How I
got there. [In the list] "Modify Settings and columns >> Add a new column
>> [Optional Settings for Column group] Show me more information >>
Calculated >> About computed and calculated columns >> [Related Topics]
Functions"
Hope this is useful!
Philip Lanier
Ascentium
"Erik" <Er...@discussions.microsoft.com> wrote in message
news:E085D3B7-A6BB-427B...@microsoft.com...
Yes, it is possible to use IF ELSE in calculated field. Use following
syntax:
=IF([Column1]="East","John Smith",IF([Column1]="West","Roger
Brown",IF([Column1]="North","Jack Tate",IF([Column1]="South","Jim Black"))))
HTH
Regards,
--SSA
http://sharepointblogs.com/ssa (All About SharePoint)
-----
"Erik" <Er...@discussions.microsoft.com> wrote in message
news:E085D3B7-A6BB-427B...@microsoft.com...