How do I assign a value to a word or letter in Numbers
example: Yes or Y has a value and No or N has a value.
then to add a chart bar/ Pie chart showing Yes and No
—–
David
MacMost Q&A Forum • View All Forum Questions • Ask a Question
How To Assign a Value To a Word or Letter In Numbers?
Comments: One Response to “How To Assign a Value To a Word or Letter In Numbers?”
Comments Closed.
Are you looking to count them? Or do you want to assign a specific value, like Yes = 37 and No = 14?
I'll assume you want to count them. You just use the COUNTIF function for that. See https://macmost.com/counting-items-with-numbers.html
So if you are using a mix of "Yes" and "Y" then you can use something like this to count them both in column B:
COUNTIF(B,"Yes")+COUNTIF(B,"Y")