View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
rrr rrr is offline
external usenet poster
 
Posts: 9
Default How do I assign a numeric value to text? IE cell = yes then 1

I am trying to create a simple list in a cell: YES or NO. Then I want to
sum the row of YES or NO's. If I can assign a value of 1 to YES and 0 to NO
I can do the math. Not sure how to assign a numeric value to a short list of
text in a cell to enable this math operation.