How do I replace a negative number with zero

ASSUMPTIONS:

1. The column in question is, say, Column B;
2. The numbers that appear in each cell in Column B is a result of a formula

Based on the above assumptions, enter this formula in Cell B1,

=if(your_formula<0,0,your_formula)

and copy down Column B until your requirements are met.

Hope this is what you are looking for.


QUOTE=Laura@Gage]Hi,
I need to somehow replace all of the negative numbers in one column
with zero. I am having issues because I already have a function in the
column that I need to do this with. Maybe something with formatting?
Please help. And thanks!


--
Laura@Gage[/QUOTE]