Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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 |
#2
|
|||
|
|||
=IF(C6=0,C1-C6,C1+C6)
Vaya con Dios, Chuck, CABGx3 "anndee" wrote in message ... 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 |
#3
|
|||
|
|||
What *is* the correct answer if your revenue from sales is zero, and
your costs are negative (I'm assuming you got a refund)? If you're entering costs as negative numbers, then you just have to add revenue and cost: = C1 + C6 (Note that the SUM() function in your example is not necessary). In article , anndee wrote: 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
how can I subtract excel cell values that contain both a number a. | Excel Discussion (Misc queries) | |||
How do I replace a negative number at the end of a formula with a. | Excel Discussion (Misc queries) | |||
how to subtract the very next LOWEST number | New Users to Excel | |||
GET.CELL | Excel Worksheet Functions | |||
How can I subtract 111 from a number like 097 and get 987, using . | Excel Worksheet Functions |