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