SOLVED

# can anyone help me with this formula??

Copper Contributor

# can anyone help me with this formula??

(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 Replies
best response confirmed by shafizulhelmi (Copper Contributor)
Solution

# Re: can anyone help me with this formula??

@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.

# Re: can anyone help me with this formula??

thank you very very very muchhhh
1 best response

Accepted Solutions
best response confirmed by shafizulhelmi (Copper Contributor)
Solution

# Re: can anyone help me with this formula??

@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.