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
|