Make the lowest value a 0

[ExcelRaceRatings]

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

 

[Toadstool]

Is this what you want?

	A	B
1	25	25
2	36	36
3	14	14
4	20	20
5	6	0

<colgroup><col style="width: 25pxpx"><col><col></colgroup><thead>
</thead><tbody>
</tbody>

ExcelRaceRatings​

Worksheet Formulas Cell Formula B1 =IF(A1=MIN($A$1:$A$5),0,A1) B2 =IF(A2=MIN($A$1:$A$5),0,A2) B3 =IF(A3=MIN($A$1:$A$5),0,A3) B4 =IF(A4=MIN($A$1:$A$5),0,A4) B5 =IF(A5=MIN($A$1:$A$5),0,A5) <thead> </thead><tbody> </tbody>

<tbody>
</tbody>