| 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 |
| 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 | |||
Threaded Mode
