Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Adding positive amount, but ignoring negative
I would like to write a formula in column C that if column Bs amount is
positive, to add it to the amount in Column A, but if the amount in column B is negative, to simply add zero to the amount in Column A. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
adding positive and negative numbers | Excel Worksheet Functions | |||
Cause formulae totals to reflect negative and positive amount inpu | Excel Discussion (Misc queries) | |||
Adding Negative and Positive Numbers | Excel Discussion (Misc queries) | |||
Adding only the negative or positive numers in a column or row | Excel Discussion (Misc queries) | |||
Change negative amount to positive. | New Users to Excel |