Math Equation Help

[bpgolferguy]

Hi, I currently have this equation in a line of code that returns a value into cell AY4 based on a value entered into AY4 to begin with:

.Value = .Value / Range("K4").Value / 100 * Range("K3").Value

The way I WANT the equation to calculate is like this:

.Value = (the value I enter into AY4) divided by the number returned from this.....K4 divided by 100 then multiplied by K3.

I know I'm probably missing some parenthesis somewhere, or maybe some brackets, but what's happening is it isn't calculating that second part by itself, then dividing it by the number I originally enter in AY4. Any suggestions? Thanks!

 

[VoG]

Try

.Value = .Value / (Range("K4").Value / 100) * Range("K3").Value

 

[djreiswig]

.Value = .Value / (Range("K4").Value / 100 * Range("K3").Value)

 

[Jonmo1]

If I read your logic right, you want the parenthesis arranged like this

.Value = .Value / ((Range("K4").Value / 100) * Range("K3").Value)

So it first does
Range("K4").Value / 100
The result of that is multiplied by K3
The result of that is devided into .Value


Is that right?

 

[bpgolferguy]

If I read your logic right, you want the parenthesis arranged like this

.Value = .Value / ((Range("K4").Value / 100) * Range("K3").Value)

So it first does
Range("K4").Value / 100
The result of that is multiplied by K3
The result of that is devided into .Value


Is that right?

That was it exactly....and it worked perfectly....thank you!

 

[djreiswig]

You really don't need the inner parenthesis as Excel will do the division and then the multiplication automatically.

See here: http://spreadsheets.about.com/od/excelformulas/ss/07excel_formula_6.htm