Forum Discussion
Issue with IFS Formula
I am trying to use an IFS formula to automatically populate a cell when another cell is a certain value. This is my formula: =IFS(F80="MD","1",F80="Self","2",F80="Other_Clinician","3",F80="PFRC","4"...
The formula (translated into german) works as expected. Can you check if there are extra spaces in the cells with "Self" and "Other_Clinician". Maybe there is "Self " and "Other_Clinician " with a space in the end.