CODEWITHSUNDEEP
excelnormalization
Jess Kropczynski
Jess Kropczynski

Reputation: 3

Normalizing Data on scale of 0 to1 in Excel

I need data in excel to return with a normalized value between 0 and 1. Following another forum, I tried the formula =A1-MIN($A$1:$A$8)/(MAX($A$1:$A$8)-MIN($A$1:$A$8)) which returns with the same value as A1. Not sure where I went wrong. Data is as follows, but should a value between 0 and 1

Upvotes: 0

Views: 8132

Answers (1)

Vinnie
Vinnie

Reputation: 553

You missed a pair of parentheses.

=(A1-MIN($A$1:$A$8))/(MAX($A$1:$A$8)-MIN($A$1:$A$8))

Upvotes: 3

Related Questions