nested IF statement with text using data validation as source

[armyprof]

So I have a user who wants to use data validation in a project tracking form. And in addition, they want to do a chart that shows percent progress. So, what I want to do is use a nested IF statement that will use the values in the data validation dropdown list to populate a cell with a numeric value.

The dropdown has the following values:

Not Started
25%
50%
75%
Completed

And the IF statement should return the following values as numbers:
Not Started = 0
25% = .25
50% = .5
75% = .75
Completed = 1

Any help would be greatly appreciated!

 

[Candyman8019]

I don't think you'll need a nested IF in this case. For example, if your data validation cell is H4, you can use a simple formula such as =H4 to get the values you're looking for.

Book1.xlsm
	H	I
4	25%	0.250
Sheet1

Cell Formulas
Range	Formula
I4	I4	=+H4

Cells with Data Validation
Cell	Allow	Criteria
H4	List	25%,50%,75%,100%

 

[armyprof]

Thanks! I agree if it were all numbers that would work. My issue is the text responses; Not started or Completed need to be changed to numbers to work. That's why I was thinking an IF statement would do it.

 

[Candyman8019]

=IF(H4="Not Started",0,IF(H4="Completed",1,H4))