View Single Post
  #1 (permalink)  
Old June 8th, 2008, 01:45 AM
ptrussell2009 ptrussell2009 is offline
Registered User
Join Date: Jun 2008
Location: , , .
Posts: 6
Thanks: 0
Thanked 0 Times in 0 Posts
Default assign numerical values to text

hey i need to make it possible to take text from 3 different drop down boxes, assign them a numerical value, then have the values added together and displayed in a different cell.

for example if from the drop down box in cell a1 was the word 'dog', and the text in b1 was 'cat' and the text in c1 was 'goat' then i need dog to be set equal to 6, cat set equal to 3, and goat set equal to 1. THEN have those values added together and be placed in cell d1.any help would be great.thanks

  a b c d
1 dog cat goat 10
Reply With Quote