Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel Equation Help
I have data in column C, that has to be processed through one of 3 possible
equations (which is inputted in column D). In column D, I am using VLOOKUP to look at column C, and then pull the right equation into column D. However, my issue is that my equations are set something like (=0.0456*x). So in column E instead of getting my values, I just get the equation. I would like to know how I can get column D, to pull in the data it needs (ie the value of x) from column C (ie the data in column C = x (in the equation)). So what I should have then is Column C Column D Column E (Value from the chosen Data Which equation to use equation and data) |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Get Excel to provide equation for my x and y | New Users to Excel | |||
How can I use Excel to solve an equation? | Excel Worksheet Functions | |||
If I don't have MS equation installed in my MS excel how should I | Excel Worksheet Functions | |||
Equation Editor- problem when editing an equation | Excel Discussion (Misc queries) | |||
equation help in excel | Excel Discussion (Misc queries) |