Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Subtraction of 2 numbers/cells
Could anyone please help me with this situation (in Excel 2003):
I have 2 cells A1 = 0 and B1 = 10 In cell C1 i put this formula C1=A1-B1 . Now the answer will be C1= -10 but my question is: Is there a formula to calculate in C1 the result if the answer is positive and if the answer is negative to put 0? Thank you in advance. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
subtraction of negative numbers | Excel Worksheet Functions | |||
entering dates results in subtraction of numbers | Excel Worksheet Functions | |||
how do I set up a simple subtraction between two cells | Excel Discussion (Misc queries) | |||
subtraction in a list of numbers that resets with a label. | Excel Worksheet Functions | |||
subtraction with time format cells | Excel Worksheet Functions |