standardize formula

[Gordon Meyer]

I have the following formula:

=STANDARDIZE(D16,D$56,D$57)

when I click on the Function fx it shows the Formula Result as being for
example -0.5728

but in the cell it puts -0.2258

I am lost

Can someone help.

Thanks.

 

[Bernie Deitrick]

Gordon,

The formula for standardizing should return:

=(D16-D$56)/D$57

That's the same as:

=STANDARDIZE(D16,D$56,D$57)

HTH,
Bernie
MS Excel MVP

 

[Gordon Meyer]

Ok but when I click on the fx before the formula input window, a window
opens up showing me x , mean and standard deviation and in the bottom of
that little screen it shows formula result and this formula result is
different than what I got in the cell ?

 

[Harlan Grove]

I have the following formula:

=STANDARDIZE(D16,D$56,D$57)

when I click on the Function fx it shows the Formula Result as being for
example -0.5728

but in the cell it puts -0.2258

If the value displayed as the cell formula's result is correct, getting
different values in the dialog is just a nuisance. What are the values in cells
D16, D56 and D57?

 

[Gordon Meyer]

Thank you so much. Just realized that the problem was a circular reference.

 

[Gordon Meyer]

Thank you so much. Just realized that the problem was a circular reference.