I am trying to write a sheet that will reference a formula from a table and have the formula calculated off of an entered value. essentially automating a process that these steps are currently done manually.
formula from a table and have the formula calculated off
of an entered value. essentially automating a process
that these steps are currently done manually.
How can I get excel to return a formula from a list of formulae and have it calculate said formula from a user defined variable? (i.e. the user defines a category and the independant variable, excel returns the apropriate formula and calculates it with the variable)
