| 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. |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Adding positive amount, but ignoring negative
=if(B10,A1+B1,A1)
drag fill down the column. -- Regards, Tom Ogilvy "Janna" wrote in message ... I would like to write a formula in column C that if column B's 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. |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Adding positive amount, but ignoring negative
How about
In C1 put the formula =if(B10,A1+B1,A1) Joe V. "Janna" wrote: 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. |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Adding positive amount, but ignoring negative
Thanks Guys!
"Janna" wrote: 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. |
| Reply |
| 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 | |||
Linear Mode
