View Single Post
  #1   Report Post  
anndee
 
Posts: n/a
Default how do i subtract a negative number

i am creating a profit and loss statement in excel. the problem that i am
having is for example: food sold - cost of food =sum(c1-c6) but if my
food sold is zero and my cost of food is a negative number this equation
gives me a positive number. i want a general equation that will give me the
correct answer if the numbers in the equation are positive or negative