Forum Discussion

rulerian9's avatar
rulerian9
Copper Contributor
Apr 10, 2023

#Div/0! error when solving for a single variable

I am trying to create a solver that will solve for Viscosity in this equation when I input variables for Velocity, mass, thickness, time, area, and gravity.  Here is my equation I am trying to creat...
excel
Excel on Mac
Formulas and Functions
Riny_van_Eekelen's avatar
Riny_van_Eekelen
Platinum Contributor
Apr 11, 2023

rulerian9 Start by creating a formula in Excel that calculates

 

=[(m*g*h)/(mu*A)]*(1+(e^((-t*mu*A)/(h*m)))-V

 

referencing each part of the equation to the relevant cell in the table with the values.

Enter any number for 'mu'.

 

Now use Goal Seek (from the Tools menu on your Mac) and set the cell with the formula to zero by changing the cell that holds the number for mu.

 

In the attached example it would look like this.

 

Note that I broke up the formula into smaller pieces as I don't really know what I'm dealing with. I would get confused otherwise. And I don't even know if I got the formula right (physics is not my line of business, sorry!).

It demonstrates the Goal Seek feature. And you can do it for any of the other variables. So if you don't know m but everything else is known, set cell E12 to 0 by changing C5. 

 

 

 

Resources