A formula for a negative figure

[Pauls123]

Hi, I have a column of numbers, most are positive numbers, eg, 1 or 2 or 3 or 3.5 etc. Where there is a negative number, eg -1.5 I want this to just become a zero , eg 0. How can I create another column, say Column A is my first, what can I put into column B. Regards, Paul

 

[jim may]

Excel 2010

	A	B
1	1	1
2	2	2
3	3	3
4	-1.5	0
5	4	4
6	5	5
7	6	6

<colgroup><col><col><col></colgroup><thead>
</thead><tbody>
</tbody>

Sheet1​

Worksheet Formulas Cell Formula B1 =IF(A1>0,A1,0) <thead> </thead><tbody> </tbody>

<tbody>
</tbody>