View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Franksta
 
Posts: n/a
Default 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