Microsoft Office Forums Need to calculate a result if a number is positive or negative.
 Register FAQ Search Today's Posts Mark Forums Read

#1
02-18-2019, 12:37 PM
 aaghd72 Windows 10 Office 2019 Novice Join Date: Feb 2019 Posts: 16
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,
Attached Files
 Help with a Formula.docx (27.1 KB, 11 views)
#2
02-19-2019, 12:46 AM
 Pecoflyer Windows 7 64bit Office 2010 64bit Expert Join Date: Nov 2011 Location: Brussels Belgium Posts: 2,397

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
02-28-2019, 07:29 AM
 bosco_yip Windows 10 Office 2016 Novice Join Date: Feb 2019 Location: Singapore Posts: 7

Perhaps,

In E9, copied down :

=IF(D9<>"",D9+E9,"")

Regards
Bosco
#4
03-01-2019, 12:34 AM
 ArviLaanemets Windows 8 Office 2016 Expert Join Date: May 2017 Posts: 467

Code:
`=SUM(\$C11,\$D11)`
I used SUM() to avoid errors whenever there are empty cells in columns C or D.

In case you want the formula to return nothing, when one component is empty, then
Code:
`=IFERROR(\$C11 + \$D11, "")`
EDIT:
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 Linear Mode

 Similar Threads Thread Thread Starter Forum Replies Last Post rsrasc Excel Programming 5 09-24-2018 12:38 PM dakm63 Excel Programming 1 05-26-2015 10:49 AM todor PowerPoint 3 01-16-2013 03:45 AM oxicottin Excel 3 12-03-2012 02:12 AM powerpointbry PowerPoint 12 06-29-2011 12:14 AM

All times are GMT -7. The time now is 07:40 PM.

 -- Default Style -- Lightweight -- New Mobile Contact Us - Privacy Statement - Top