Sharepoint List calculated value query

Question

I have a choice column with 5 options, I have attempted to write the following statement with no errors identified by the system.

=IF([RTS-GCS]="15-13","4",IF([RTS-GCS]="12-9","3",IF([RTS-GCS]="8-6","22,IF([RTS-GCS]="5-4","1",IF([RTS-GCS]="3","0","N/A")))))

If is select any of the following for the choice dropdown I need the numerical value associated to be returned in the GCS_Score column.

Choice [RTS_GCS] column	Associated Numeric Value
15-13	4
12-9	3
8-6	2
5-4	1
3	0

Currently I always get "N/A" in the GCS_Score column no matter what choice option I select.

What have I not done correctly?

Answer 1

Hi David,

Thanks for posting back.

I'm glad to know you have found the root cause and resolved the issue. If you encounter any issues while using Office products, please feel free to post in our community and we are happy to help.

Have a Nice day!

Sincerely,

George | Microsoft Community Moderator

Answer 2

Hi David,

Thanks for posting in the community. We are happy to help you.

According to the formula you shared, there is an error in it. However, I think you may have caused the error when you manually entered the formula in your post. The error should not cause what you are experiencing. It should be

'..IF([RTS-GCS]="8-6","2**",IF(..', not '"8-6","22,**IF(…'.

Based on the above, I have tested one of the following formulas and they all work well.

=IF([RTS-GCS]="15-13","4",IF([RTS-GCS]="12-9","3",IF([RTS-GCS]="8-6","2",IF([RTS-GCS]="5-4","1",IF([RTS-GCS]="3","0","N/A")))))

=IF([RTS-GCS]="15-13",4,IF([RTS-GCS]="12-9",3,IF([RTS-GCS]="8-6",2,IF([RTS-GCS]="5-4",1,IF([RTS-GCS]="3",0,"N/A")))))

![](https://learn-attachment.microsoft.com/api/attachments/e3e7e320-52b6-43b8-be8c-d93d06f0d423?platform=QnA"2">

Please check the symbols in your formula.

Make sure that the symbol "-" in the formula is the same as the symbol in Choice options. Also, make sure that each values with the symbol "-" in the formula are the same. To verify this, you can copy/paste the formula in Notepad or Word, then use the Find or Replace feature to check.

3. I noticed that you have two other columns “RTS-SBP” and “RTS-RR”. I would like to know if they are calculated columns. If so, please provide their formulas.

We look forward to your response. Thanks for your cooperation.

Sincerely,

George | Microsoft Community Moderator

Answer 3

Hi George,

Thank you very much.

Item 1, I have restructured the options and now this has helped to fix my issue. There were some blank spaces at the end of some options.

Item 2 I have restarted building with a modification to the structure of the column names, I have removed "-" and inserted "_", this has made it easier to read.

Item 3, I have had to apply the same requirements within the structure of the columns and the options to these columns as per items 1 & 2 above, I now have a all section working.

Thanks very much for your guidance. I do appreciate the time to help me resolve my issue.

Regards,

David.