Return a value based on different parameters

The user has a spreadsheet with a dropdown list in one column. They want another column to automatically display a specific percentage based on the selected dropdown option. The dropdown offers six choices: Not Started, Started, In Progress, Nearly There, Complete, and an implied sixth option. The desired corresponding return values are 0%, 25%, 50%, 75%, and 100%. The user found a formula that works for two conditions but fails when extended to cover all the options. The extended formula uses nested IF statements with the SEARCH function. When attempting to use the formula for all five specified options, it generates a parenthesis error. The user is asking for assistance in correcting the formula to accommodate all the required conditions. The current formula structure is causing an error, likely due to an imbalance of parentheses or incorrect nesting. The core problem is extending a nested IF formula beyond a certain complexity without it breaking.