#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.
__________________
Problem solved ? Let others know by clicking " Thread Tools" then " Mark thread as solved".( This can be undone if need be) Want to thank for the help received ? Click the scales symbol in the upper right corner of a post from the person you want to thank. 
#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  09242018 12:38 PM 
Excel VBA to convert number to negative  dakm63  Excel Programming  1  05262015 10:49 AM 
Custom formatting to make negative numbers show w/o negative sign on charts  todor  PowerPoint  3  01162013 03:45 AM 
If formula result is negative then display text  oxicottin  Excel  3  12032012 02:12 AM 
Start slides from a negative number  powerpointbry  PowerPoint  12  06292011 12:14 AM 