Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Solver Question
My equation calculates an interest rate
A1*C1^B1 + A2*C1^B2 + ... + A11*C1^B11 = D1 Columns A, B and D are given. The only unknown is C1 which I want to solve for. I can do this using solver but I would like something that updates when columns B and D change. Can I do this without using the solver or have the solver automatically update? Thanks, G |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
webquery and solver macros | Excel Discussion (Misc queries) | |||
Solver question | Excel Worksheet Functions | |||
Solver does not work from Macros | Setting up and Configuration of Excel | |||
Solver parameter constraint question | Excel Discussion (Misc queries) | |||
question on excel Solver | Excel Worksheet Functions |