hello all,
I've been trying to figure this out all afternoon & everytime I think I'm close to a solution, it throws up more barriers...
I have now assigned values to a number of text cells, and put these in a drop box (via Data Validation). I need the value of the text to multiply by data entered into another column (and which is variable).
More specific:
Column C is time spent (entered as .25, .5, .75 or 1).
Column D is a drop box (repeated in each cell down), where one of 4 choices is possible: Heavy, Medium, Light, Relax and each of these is assigned a value (6, 4, 2, -2). The values for these -for the Data Validation- are in K5:L8.
What I'm trying to get in Column E: Time spent*Value assigned to "text" selected from the drop box.
The multiplication does work if I use =C4*heavy or =C4*light so I know I got that part right, but that kinda defeats the whole purpose of what I want to do. I want to select a factor and have it come up with result by itself, without inputting the whole everytime!!
HELP!?
Thanks!
Bookmarks