How to assign numerical value to a list?

SleepyTiger2013 

In Excel for the web, you can use the following approach to assign numerical values to your list and calculate the percent complete:

1. Select the cell where you want to display the percent complete.
2. Go to the "Insert" tab in the Excel for the web toolbar and click on "Dropdown."
3. In the dropdown menu, select "Data Validation."
4. In the data validation settings, choose "List" as the validation criteria.
5. In the "Source" field, enter the following values: "Not Started,In Progress,Completed" (without quotes).
6. Click "OK" to apply the data validation to the selected cell.
7. Now, in a separate cell, you can use the following formula to calculate the percent complete based on the selected value:

=IF(A1="Not Started",0,IF(A1="In Progress",50,IF(A1="Completed",100,"")))

Replace A1 with the cell reference of the selected cell.

This formula checks the value in the selected cell and assigns the corresponding numerical value: 0 for "Not Started," 50 for "In Progress," and 100 for "Completed."

To get the overall progress color read-out, you can use conditional formatting based on the calculated percent complete. Select the range of cells you want to format, go to the "Home" tab, click on "Conditional Formatting," and choose "Color Scales" or "Icon Sets" to apply color formatting based on the percent complete.

Please note that Excel for the web may have limitations compared to the desktop version, so some advanced features may not be available.