STANDARDIZE gives wrong answer

[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.

 

[Ron Rosenfeld]

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.

Using the values in Excel HELP I see no difference in the results when clicking
on the fx or looking in the cell.

However, since I don't know what is in D16, D$56 or D$57 of *your* worksheet,
it's hard for me to troubleshoot further.


--ron