Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 02-18-2019, 12:37 PM
aaghd72 aaghd72 is offline Need to calculate a result if a number is positive or negative. Windows 10 Need to calculate a result if a number is positive or negative. Office 2019
Novice
Need to calculate a result if a number is positive or negative.
 
Join Date: Feb 2019
Posts: 15
aaghd72 is on a distinguished road
Question 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
File Type: docx Help with a Formula.docx (27.1 KB, 17 views)
Reply With Quote
  #2  
Old 02-19-2019, 12:46 AM
Pecoflyer's Avatar
Pecoflyer Pecoflyer is offline Need to calculate a result if a number is positive or negative. Windows 7 64bit Need to calculate a result if a number is positive or negative. Office 2010 64bit
Expert
 
Join Date: Nov 2011
Location: Brussels Belgium
Posts: 2,766
Pecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant future
Default

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
Reply With Quote
  #3  
Old 02-28-2019, 07:29 AM
bosco_yip bosco_yip is offline Need to calculate a result if a number is positive or negative. Windows 10 Need to calculate a result if a number is positive or negative. Office 2016
Novice
 
Join Date: Feb 2019
Location: Singapore
Posts: 7
bosco_yip is on a distinguished road
Default

Perhaps,

In E9, copied down :

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

Regards
Bosco
Reply With Quote
  #4  
Old 03-01-2019, 12:34 AM
ArviLaanemets ArviLaanemets is offline Need to calculate a result if a number is positive or negative. Windows 8 Need to calculate a result if a number is positive or negative. Office 2016
Expert
 
Join Date: May 2017
Posts: 869
ArviLaanemets has much to be proud ofArviLaanemets has much to be proud ofArviLaanemets has much to be proud ofArviLaanemets has much to be proud ofArviLaanemets has much to be proud ofArviLaanemets has much to be proud ofArviLaanemets has much to be proud ofArviLaanemets has much to be proud ofArviLaanemets has much to be proud of
Default

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))
Reply With Quote
Reply

Tags
formula, negative, positive

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Need to calculate a result if a number is positive or negative. Need Macro to Convert Numbers from Positive to Negative rsrasc Excel Programming 5 09-24-2018 12:38 PM
Need to calculate a result if a number is positive or negative. 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
Need to calculate a result if a number is positive or negative. 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

Other Forums: Access Forums

All times are GMT -7. The time now is 10:30 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2024, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2024 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft