- Messages
- 2,881
- Name
- Chris
- Edit My Images
- Yes
I have no idea why I am having problems with this so grateful for any help.
I need to use a value from a word in a formula.
Example: Assessment x 100 = 50
Assessment is a drop down option but needs to have a value of 0.5.
Delivery (another drop down option) needs to have a value of 0.9.
Complete needs to have a value of 1.
There are loads of others but you get the idea.
I'm thinking that the word needs to be a variable but cannot see how to set a variable. Else the words need to be in a VLOOKUP.
Any thoughts gratefully received.
I need to use a value from a word in a formula.
Example: Assessment x 100 = 50
Assessment is a drop down option but needs to have a value of 0.5.
Delivery (another drop down option) needs to have a value of 0.9.
Complete needs to have a value of 1.
There are loads of others but you get the idea.
I'm thinking that the word needs to be a variable but cannot see how to set a variable. Else the words need to be in a VLOOKUP.
Any thoughts gratefully received.