ExcelRaceRatings
New Member
- Joined
- Jan 9, 2016
- Messages
- 25
- Office Version
- 2016
- Platform
- Windows
Hello,
If i have a series of numbers as per the below, how do i make the lowest value return a 0?
A1 - 25
A2 - 36
A3 - 14
A4 - 20
A5 - 6
In B1:B5 i need
B1 - 25
B2 - 36
B3 - 14
B4 - 20
B5 - 0
Thank you
If i have a series of numbers as per the below, how do i make the lowest value return a 0?
A1 - 25
A2 - 36
A3 - 14
A4 - 20
A5 - 6
In B1:B5 i need
B1 - 25
B2 - 36
B3 - 14
B4 - 20
B5 - 0
Thank you