Hi! I am having trouble with this formula. I have a data validation drop down list in one cell that has the following choices:
Not contacted yet
Contacted: awaiting answer
Meeting has been set up
Converted into New Affiliate!
Contacted: Not interested
Next to that, I want a value listed for each choice so that i can do a pie chart. The values would be:
Not contacted yet- 0
Contacted: awaiting answer- 10
Meeting has been set up- 20
Converted into New Affiliate!- 30
Contacted: Not interested- 5
This is the formula I came up with, but it's not working. What do you guys think?
=IF((OR(C3>="Not contacted yet", "Contacted: awaiting answer","Meeting has been set up","Converted into New Affiliate!", "Contacted: Not interested")), "0", "10","20","30","5"))))
Bookmarks