only postive numbers

[Tom H. Lautenbacher]

Hello NG,

I am having a column, in wich numbers are continoously deducted from a
value.
at some line, it reaches zero, and after this line it goes into negative
numbers.

now i want, that after reaching 0, that all following numbers are roundet up
to 0, too, instead of beeing negative.

any hint for me?

thanx,
tom.

 

[Tom H. Lautenbacher]

One way:

Assume numbers are in column B and deductions are in column C:

B2: =MAX(B1-C1,0)

or

=MAX(B$1-SUM(C$1:C1),0)

and drag down as far as necessary, so the result would be something
like:

B C
1 10 4
2 6 2
3 4 5
4 0 2
5 0 ...

Super, thanx a lot!!

Cu,
Tom

 

[J.E. McGimpsey]

One way:

Assume numbers are in column B and deductions are in column C:

B2: =MAX(B1-C1,0)

or

=MAX(B$1-SUM(C$1:C1),0)

and drag down as far as necessary, so the result would be something
like:

B C
1 10 4
2 6 2
3 4 5
4 0 2
5 0 ...

 

[immanuel]

Assuming you have a formula like the following in your cell:

=D5-C6

You could use this in its stead:

=IF(D5-C6<0,0,D5-C6)

If you need more specific help, please post your formula.

/i.