IF formula with single select dropdown
I could use some help with the IF formula when trying to add a value to a single-select drop down.
I am using percentage to track a customers completion of our program. I have a column labeled "Sleep Study" with the drop down options of Required, Not Required, Complete - records requested, Complete - records received.
When the option "Required" is selected, I want it to subtract from the total percentage, so I assign it as a negative number using the IF formula. From what I've read on other's similar issues, I should be using the formula: =IF(Sleep Study = "Required", -0.1) but it comes back as Unparseable. I also tried =IF(Sleep Study = "Required"@row, -0.1) as some of our other formulas require the row, but that doesn't work either. I don't need any of the other drop down options to contribute to the percentage.
Help Article Resources
Check out the Formula Handbook template!