chandrashekar
Well-known Member
- Joined
- Jul 15, 2005
- Messages
- 517
- Office Version
- 365
- Platform
- Windows
Hello,
Could you please share formula to fix Max and Min value.
Example1
values: 3.2, 7.3, 10.2, 12.9
Minimum = 3 - need formula where will I get 0
Maximum = 12 - need formula where will I get 20
Example2
values: 5.1, 9.3, 18.2, 12.9
Minimum = 5.1 - need formula where will I get 0
Maximum = 18.2 - need formula where will I get 20
Example2
values: 23.1, 24.2, 80.2, 97.9
Minimum = 23.1 - need formula where will I get 20
Maximum = 97.9 - need formula where will I get 100
Regards,
Chandrashekar B
Could you please share formula to fix Max and Min value.
Example1
values: 3.2, 7.3, 10.2, 12.9
Minimum = 3 - need formula where will I get 0
Maximum = 12 - need formula where will I get 20
Example2
values: 5.1, 9.3, 18.2, 12.9
Minimum = 5.1 - need formula where will I get 0
Maximum = 18.2 - need formula where will I get 20
Example2
values: 23.1, 24.2, 80.2, 97.9
Minimum = 23.1 - need formula where will I get 20
Maximum = 97.9 - need formula where will I get 100
Regards,
Chandrashekar B