an excel formula for specific conditions
 

just thought of it again and you may want to change the formula for row 4 to
the following:

=IF(B3=0,0,B3)

just to ensure that if the value is 0 that it won't be considered to be a
negative value and changing the end result :) oops