STANDARDIZE gives wrong answer

  • Thread starter Thread starter Gordon Meyer
  • Start date Start date
G

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.
 
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.
Click to expand...

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
 
Back
Top