Return to Question

deleted 34 characters in body

Source Link

edited Mar 11, 2016 at 16:41

I currently have a list with the Column - "Level" This column is a choice column with the choices: "Novice" and "Beginner"

I'm creating a calculated column called "Score" I want this column to produce "1" if "Level" is Novice, and "2" if "Level" is Beginner

My Code I've been trying to use is..

=IF([Level]="Novice",[Score]="1"),
IF([Level]="Beginner",[Score]="2")

Can someone help clear up my confusions? Thanks

Edit: found solution ignore please

I currently have a list with the Column - "Level" This column is a choice column with the choices: "Novice" and "Beginner"

I'm creating a calculated column called "Score" I want this column to produce "1" if "Level" is Novice, and "2" if "Level" is Beginner

My Code I've been trying to use is..

=IF([Level]="Novice",[Score]="1"),
IF([Level]="Beginner",[Score]="2")

Can someone help clear up my confusions? Thanks

Edit: found solution ignore please

I currently have a list with the Column - "Level" This column is a choice column with the choices: "Novice" and "Beginner"

I'm creating a calculated column called "Score" I want this column to produce "1" if "Level" is Novice, and "2" if "Level" is Beginner

My Code I've been trying to use is..

=IF([Level]="Novice",[Score]="1"),
IF([Level]="Beginner",[Score]="2")

Can someone help clear up my confusions? Thanks

Source Link

asked Mar 11, 2016 at 16:36

Calculated Column Question

I currently have a list with the Column - "Level" This column is a choice column with the choices: "Novice" and "Beginner"

I'm creating a calculated column called "Score" I want this column to produce "1" if "Level" is Novice, and "2" if "Level" is Beginner

My Code I've been trying to use is..

=IF([Level]="Novice",[Score]="1"),
IF([Level]="Beginner",[Score]="2")

Can someone help clear up my confusions? Thanks

Edit: found solution ignore please

2010 column