Forum Discussion
Solved
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.
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.
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.
- thank you very very very muchhhh
