#1
|
|||
|
|||
Need to calculate a result if a number is positive or negative.
One column is Budget, one is Adjusted Amount, and the last is Total. I am having trouble writing a formula for the Total column because the Adjusted Amount can be a negative or a positive. I can't figure out how to make this work. I appreciate any help you can provide. Thanks, |
#2
|
||||
|
||||
Please post a worksheet. A Word document cannot be worked upon.
__________________
Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post |
#3
|
|||
|
|||
Perhaps,
In E9, copied down : =IF(D9<>"",D9+E9,"") Regards Bosco |
#4
|
|||
|
|||
Code:
=SUM($C11,$D11) In case you want the formula to return nothing, when one component is empty, then Code:
=IFERROR($C11 + $D11, "") I looked again at your Word image. Do you really want to be the formula result be bigger than Current Budget in case Adjusted Budget is negative? Very strange logic, but whatever! Code:
=SUM($C11) + ABS(SUM($D11)) |
Tags |
formula, negative, positive |
Thread Tools | |
Display Modes | |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Need Macro to Convert Numbers from Positive to Negative | rsrasc | Excel Programming | 5 | 09-24-2018 12:38 PM |
Excel VBA to convert number to negative | dakm63 | Excel Programming | 1 | 05-26-2015 10:49 AM |
Custom formatting to make negative numbers show w/o negative sign on charts | todor | PowerPoint | 3 | 01-16-2013 03:45 AM |
If formula result is negative then display text | oxicottin | Excel | 3 | 12-03-2012 02:12 AM |
Start slides from a negative number | powerpointbry | PowerPoint | 12 | 06-29-2011 12:14 AM |