Support Board

Date/Time: Sun, 24 Nov 2024 09:07:32 +0000

Post From: normalization question

[2024-06-11 17:54:15] Link To Thread - Link To Post [Go To First Post]
User411320 - Posts: 289
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


Screenshot 2024-06-10 130823.png / V - Attached On 2024-06-11 17:53:55 UTC - Size: 15.6 KB - 61 views Screenshot 2024-06-11 134722.png / V - Attached On 2024-06-11 17:54:05 UTC - Size: 23.18 KB - 52 views