Support Board
Date/Time: Thu, 15 May 2025 21:36:58 +0000
Post From: normalization question
[2024-06-11 17:54:15] |
User411320 - Posts: 320 |
Hello, I'm attempting a normalization formula (seen in the picture) but I'm not getting the result of 0 and 1. Instead I'm getting values greater than 1 and less than 0 (seen in the other picture). I wrote the formula from the picture as =(E3-$V$3)/($W$3-$V$3). E (last price) V (MIN function of E) W (Max function of E) any help would be appreciated |
![]() ![]() |