can anyone help me with this formula??

[shafizulhelmi]

(english is not my 1st language hoping anyone can understawanted the net to show "0" instead of negative numbers, anyone know the formula ? also can its also count all the NET even all the gross not yet finish, so it will automatically show me the present calculation of the net. Now i try it cannot coz it will also count the negative figure.

[#2 · Accepted solution]

@shafizulhelmi Try using the MAX function instead of SUM:

=MAX(P9-$E9,0)

Note: the $ sign before E9 allows you to copy/paste the formula to the other columns/rows and maintain the reference to column E.

From there, you can add up all of the NET amounts as needed.

[#3]

thank you very very very muchhhh