Macro Using Squared Not Functioning

[honkin]

I have a macro I am trying to develop, but at the moment, it simply sits there still as a macro

What I am after in English is the following:-

Number of Runners = F2
Expected Winners = F3
Winners = F4

So the formula in English is runners x (winners – expectedwinners)² / expectedwinners x (runners – expectedwinners)

I tried the following to achieve this, but nothing happens at all

=F2*(F4-F3)^2/F3*(F2-F3)

I even tried it not using the squared symbol, but instead tried using power =

=POWER(F4-F3,2)*F2/F3*(F2-F3)

Any thoughts on the best way to write this to have it function correctly?

cheers

 

[joeu2004]

Here is what I'm after as a fraction using words

I tried the following to achieve this, but nothing happens at all
=F2*(F4-F3)^2/F3*(F2-F3)

What you had originally is very close. Pay close attention to operator order precedence (click here). But there is no need to over-parenthesize, which obscures readability.

Book1
	E	F	G	H
2	runs	122327
3	exp wins	15112
4	actl wins	12846	exact	residual
5	ratio	387.67	387.672184308198	+4.55E-13
6		387.67
Sheet1

Select or hover cursor over cells to see formulas.

The key formulas are:

F5: =F2 * (F4-F3)^2 / (F3 * (F2-F3))
F6: =ROUND(F2*(F4-F3)^2/(F3*(F2-F3)), 2)

Note that F5 is formatted to display only 2 decimal places, but its actual value might have many more decimal places (see G5 and H5).

If you want the actual value to have only 2 decimal places, you should explicitly round, as demonstrated in F6

 

[honkin]

search for
What is the hierarchy of mathematical operators in Excel
Excel precedence order

Understood mate. So the formula was correct, just not expresses with the right syntax. I need to get a handle on using parenthesis to separate parts of formulas. Thanks so much for your help, both with the formula as well as the heads up to look at the order of operations. That does help to clarify

cheers