Penny Arcade Forums› Help / Advice Forum
The new forums will be named Coin Return (based on the most recent vote)! You can check on the status and timeline of the transition to the new forums here.
The Guiding Principles and New Rules document is now in effect.

Excel Question: Making a Negative Positive

SkyGheNeSkyGheNe Registered User regular
edited February 2010 in Help / Advice Forum
I'm working with an excel spreadsheet and want it set up so that if a number is negative after a calculation, it becomes positive. This becomes complicated when I'm working with something like this:

=SUM(D6 : D15)-(G5)

Any help?

SkyGheNe on

Posts

  • ecco the dolphinecco the dolphin Registered User regular
    edited February 2010
    So you want SUM(D6:D15) to always be positive?

    Try:

    ABS(SUM(D6:D15))

    Edit: Darned smiley faces!

    ecco the dolphin on
    Penny Arcade Developers at PADev.net.
  • SkyGheNeSkyGheNe Registered User regular
    edited February 2010
    eeccccoo tthhee ddoollpphhiinn wrote: »
    So you want SUM(D6:D15) to always be positive?

    Try:

    ABS(SUM(D6:D15))

    Edit: Darned smiley faces!

    Thanks! That worked perfectly!

    SkyGheNe on
  • SkyGheNeSkyGheNe Registered User regular
    edited February 2010
    nvm got it!

    SkyGheNe on
Sign In or Register to comment.
Penny Arcade Forums› Help / Advice Forum