how to use if function to calculate common cost in income stateme.
 

I have a owner who only wants to receive his common cost if the business
earns a profit. ( Net income 0). I used th e absulet value of the net income
sell 0,then the owners percentage time the gross profit for my true
statement and if false 0.
This function althought yielding the correct result will not correctly
populate or change the common cost cell if Groos sales change the amount of
net income to 0.