Hi,<?xml:namespace prefix = o ns = "urn:schemas-microsoft-comfficeffice" /><o></o>
<o></o>
I have a data validation list with text values, each text value theoretically has a numerical value. I need to calculate the theoretical value when a corresponding text value is chosen.<o></o>
Can anyone help?<o></o>
I.e. the text value is sometimes and carries a numerical value of 1. If I have several questions that are answered with the sometimes answer I need to calculate the total of all the answers. Thanks much<o></o>
<o></o>
I have a data validation list with text values, each text value theoretically has a numerical value. I need to calculate the theoretical value when a corresponding text value is chosen.<o></o>
Can anyone help?<o></o>
I.e. the text value is sometimes and carries a numerical value of 1. If I have several questions that are answered with the sometimes answer I need to calculate the total of all the answers. Thanks much<o></o>