Number formatting

Question

I have a two choice columns that display same three choices: 0, 3, 9

Column 1 has a value of 9

Column 2 has a value of 3

I want to add 9 and 3 on a new column.

Something so simple is giving me issues? Can anyone assist?

Ganesh Sanap - MVP · Accepted Answer · 2020-11-03 11:08:45Z

1

Assuming you have two columns named: Choice1 and Choice1.

Then you can create a new Calculated column in your list and use below formula:

=[Choice1]+[Choice1]

Output:

Microsoft official Reference: Calculated Field Formulas

answered Nov 3, 2020 at 11:08

42.9k21 gold badges30 silver badges58 bronze badges

Ganesh, thanks amillion for your support! It worked :)
– Jose1978
Nov 3, 2020 at 12:31
Hi @Jose1978, Please Upvote(^) and accept it as an Answer as it helped you and it will help others with same problem in future. It also removes this question from "Unanswered questions" list.
– Ganesh Sanap - MVP
Nov 24, 2020 at 15:37

Add a comment |

1 Answer 1