Need to calculate a result if a number is positive or negative.

		Microsoft Office Forums > Microsoft Excel > Excel
Need to calculate a result if a number is positive or negative.

FAQ

Thread Tools

Display Modes

03-01-2019, 12:34 AM

ArviLaanemets ArviLaanemets is offline

Need to calculate a result if a number is positive or negative.

Windows 8

Office 2016

Expert

Join Date: May 2017

Posts: 961

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

« Previous Thread | Next Thread »

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

Other Forums: Access Forums

All times are GMT -7. The time now is 05:48 PM.