HOW TO TREAT NEG NUMBERS AS ZEROS?

[Achilles]

I would like to perform some arithmetical operations on a column of figures in EXCEL. How do I get the formula to treat any number which is less than zero in value, as if its value is zero?( i.e. if x<0, then x=0) I hope that someone here can help when they can. Thanks in advance................Jack

[Achilles]

.....I figured it out using the max function.

[Dave Schwartz]

Originally Posted by Achilles

I would like to perform some arithmetical operations on a column of figures in EXCEL. How do I get the formula to treat any number which is less than zero in value, as if its value is zero?( i.e. if x<0, then x=0) I hope that someone here can help when they can. Thanks in advance................Jack

Sorry I missed this.

Very simple:
1. Column A is a column of values
10
20
0
-10
-20
50

2. Column B is created from column A using this formula:
=(A1>0) * A1

[Achilles]

I did it by using MAX(0,J2) to create a duplicate column of figs that I could plug into a formula in another column. Your formula seems pretty slick, like I could plug it right into the formula and avoid creating a redundant column. I'll give that a try later.
Thanks again for answering.................Jack

[cj]

Originally Posted by Achilles

I did it by using MAX(0,J2) to create a duplicate column of figs that I could plug into a formula in another column. Your formula seems pretty slick, like I could plug it right into the formula and avoid creating a redundant column. I'll give that a try later.
Thanks again for answering.................Jack

Why not just plug MAX(0,J2) into the formula itself so you don't have to create another column?

[Achilles]

Hi C.J.


Actually (RED BOARD ALERT) I did that, and guess what?..........It worked!


Thanks for your interest.................Jack