+ Reply to Thread
Results 1 to 2 of 2

I need Positive and Negative values working together

  1. #1
    Registered User
    Join Date
    12-06-2015
    Location
    Michigan
    MS-Off Ver
    Office 365
    Posts
    79

    Question I need Positive and Negative values working together

    A1= 13.44
    B1= 2.68
    =A1*20%, gives you the result for B1

    But what if i want to stay with a 20% +/- margin if A2 was a negative? EX:
    A2= -13.44
    B2= -2.68, I need this number to be higher then the A2 result

    I need a formula that can have, +/-, both work together

  2. #2
    Forum Expert
    Join Date
    05-05-2015
    Location
    UK
    MS-Off Ver
    Microsoft Excel for Microsoft 365 MSO (Version 2402 Build 16.0.17328.20068) 64-bit
    Posts
    28,152

    Re: I need Positive and Negative values working together

    How can 20% be higher? Do you mean that b2= +2.68

    =ABS(A2* 0.2)

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. NoobQ: Rank function treats negative values as positive values. Help!
    By lutonoodles in forum Excel Formulas & Functions
    Replies: 8
    Last Post: 10-12-2013, 02:10 PM
  2. Looking for a positive value ABOVE negative values
    By ckatzman in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 10-05-2012, 08:54 PM
  3. Replies: 8
    Last Post: 07-28-2012, 03:22 PM
  4. Replies: 2
    Last Post: 06-18-2012, 04:26 PM
  5. Convert negative to positive in sheet containing both positive/negative numbers
    By sa02000 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 05-29-2010, 07:52 PM
  6. Smear ut negative values over positive
    By a94andwi in forum Excel General
    Replies: 4
    Last Post: 02-23-2007, 04:12 AM
  7. Replies: 4
    Last Post: 09-26-2005, 06:05 PM
  8. [SOLVED] switching values from positive to negative
    By lob in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 02-18-2005, 07:06 PM

Tags for this Thread

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1