Using a variable like "x" in excel

**SamLeijen** · 05-12-2018, 07:12 PM

Hi all

here is my formula
14=(93.4-x)0.088+(x).509+(5).179
How can excel extract the value for x?
Currently at a loss to find the answer.
Thanks in advance

**6StringJazzer** · 05-12-2018, 07:46 PM

Excel cannot solve an equation like that for a variable the same way a person would. You can, however, use Solver to iteratively find a solution.

You would place a value in a cell, such as A1. Then you would express your equation as an Excel formula, using A1 for x. For example, put this in B1:

=(93.4-A1)*0.088 + A1*0.509 + 5*0.179

Then you would open Solver, identify A1 as the value to vary, and set the goal as B1=14.

You will have to bring up Help for Solver for a more complete explanation of how it works; it is too much for me to write out in a post where there is already a lot written about it.

**SamLeijen** · 05-12-2018, 07:49 PM

Thanks for that reply
I will try it out shortly

**SamLeijen** · 05-12-2018, 07:55 PM

That worked
Must practice using solver as it failed twice. Third time lucky

Thanks very much

**Alf** · 05-13-2018, 07:09 AM

There is also the possibility of using "Goal Seek" fond under "Data" tab, "What-If Analysis"

a_goal_seek.jpg

a2_goal_seek.jpg

"," is the Scandinavian delimiter for decimals.

Alf

Using a variable like "x" in excel

LinkBack

Thread Tools

Rate This Thread

Display

Using a variable like "x" in excel

Re: Using a variable like "x" in excel

Re: Using a variable like "x" in excel

Re: Using a variable like "x" in excel

Re: Using a variable like "x" in excel

Thread Information

Users Browsing this Thread

Similar Threads

use variable in Workbooks("book1").Worksheets("sheet1").Range("a1"

[SOLVED] why is it saying sheetcnt is "variable not defined" how to do a global variable to share over multiple functions in vba for excel?

[SOLVED] why is it saying sheetcnt is "variable not defined" how to do a global variable to share over multiple functions in vba for excel?

why is it saying sheetcnt is "variable not defined" how to do a global variable to share over multiple functions in vba for excel?

[SOLVED] why is it saying sheetcnt is "variable not defined" how to do a global variable to share over multiple functions in vba for excel?

[SOLVED] why is it saying sheetcnt is "variable not defined" how to do a global variable to share over multiple functions in vba for excel?

why is it saying sheetcnt is "variable not defined" how to do a global variable to share over multiple functions in vba for excel?

why is it saying sheetcnt is "variable not defined" how to do a global variable to share over multiple functions in vba for excel?

Bookmarks

Bookmarks

Posting Permissions