Microsoft Office Forums

Go Back   Microsoft Office Forums > Microsoft Excel > Excel

LinkBack Thread Tools Display Modes
Old 02-18-2019, 12:37 PM
aaghd72 aaghd72 is offline Windows 10 Office 2019
Join Date: Feb 2019
Posts: 16
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, 11 views)
Reply With Quote
Old 02-19-2019, 12:46 AM
Pecoflyer's Avatar
Pecoflyer Pecoflyer is offline Windows 7 64bit Office 2010 64bit
Join Date: Nov 2011
Location: Brussels Belgium
Posts: 2,386
Pecoflyer is a glorious beacon of lightPecoflyer is a glorious beacon of lightPecoflyer is a glorious beacon of lightPecoflyer is a glorious beacon of lightPecoflyer is a glorious beacon of lightPecoflyer is a glorious beacon of light

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.
Reply With Quote
Old 02-28-2019, 07:29 AM
bosco_yip bosco_yip is offline Windows 10 Office 2016
Join Date: Feb 2019
Location: Singapore
Posts: 7
bosco_yip is on a distinguished road


In E9, copied down :


Reply With Quote
Old 03-01-2019, 12:34 AM
ArviLaanemets ArviLaanemets is offline Windows 8 Office 2016
Join Date: May 2017
Posts: 436
ArviLaanemets will become famous soon enoughArviLaanemets will become famous soon enough

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
=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!
=SUM($C11) + ABS(SUM($D11))
Reply With Quote

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

All times are GMT -7. The time now is 11:12 PM.

Powered by vBulletin® Version 3.8.1
Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
SEO by vBSEO ©2011, Crawlability, Inc. is not affiliated with Microsoft