Loading
Ozgrid Excel Help & Best Practices Forums

Excel Video Tutorials / Excel Dashboards Reports



Results 1 to 2 of 2

Thread: Percent Formula Positive Negative Numbers

  1. #1
    Join Date
    15th June 2007
    Posts
    1

    Percent Formula Positive Negative Numbers

    I need a percent increase or decrease formula using a mix of both positive and negative numbers. EX: positive # to positive #, positive # to negative #, negative # to positive #,
    negative # to negative #.

    Excel Video Tutorials / Excel Dashboards Reports


  2. #2
    Join Date
    23rd December 2003
    Location
    St. Louis, MO
    Posts
    446

    Re: Percent Formula Positive Negative Numbers

    Try =Abs("Number1"-"Number2")/Abs("Number1")

    Excel Video Tutorials / Excel Dashboards Reports


Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Possible Answers

  1. Convert Positive Numbers To Negative
    By Markw in forum EXCEL HELP
    Replies: 5
    Last Post: January 9th, 2008, 18:47
  2. Replies: 1
    Last Post: May 15th, 2007, 07:05
  3. Sum Positive and Negative Numbers regardless of Sign
    By Austin Martin in forum EXCEL HELP
    Replies: 5
    Last Post: July 15th, 2006, 12:57
  4. Negative numbers to positive
    By wsim in forum EXCEL HELP
    Replies: 10
    Last Post: April 1st, 2006, 04:50
  5. Storing positive numbers as negative
    By zed_raz in forum EXCEL HELP
    Replies: 5
    Last Post: March 24th, 2006, 11:24

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
porno