Penny Arcade Forums› Help / Advice Forum
As was foretold, we've added advertisements to the forums! If you have questions, or if you encounter any bugs, please visit this thread: https://forums.penny-arcade.com/discussion/240191/forum-advertisement-faq-and-reports-thread/
Options

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

  • Options
    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.
  • Options
    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
  • Options
    SkyGheNeSkyGheNe Registered User regular
    edited February 2010
    nvm got it!

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