Calculated Column Condition in SharePoint
For creating a calculated column that is dependent on the other column which is in the same list , we can create in the browser itself. No need for the Sharepoint Designer.
Create a Column for Calculated List...
Identify the list which we have to lookup for calculation...
=IF([Column Name]="Condition one","Set this value one",IF([Column Name]="Condition Two","Set this value two"))
Like this we can add N conditions...