+ Reply to Thread
Results 1 to 4 of 4

Subtracting the results of a formula

  1. #1
    Registered User
    Join Date
    12-06-2004
    Location
    Eldorado, Texas
    Posts
    24

    Subtracting the results of a formula

    In A1 I have this: $9.50.
    In A2 I want to display the result of multiplying A1 with 10% and subtracting the result from A1.

    I've tried this in A2: =SUM(A1*10%)-SUM(A1)
    But it displays a negative number: -$8.55

    I need it to display: $8.55
    Last edited by David A; 10-07-2008 at 11:36 PM.

  2. #2
    Registered User
    Join Date
    12-06-2004
    Location
    Eldorado, Texas
    Posts
    24
    OK, I figured it out: =SUM(B98-(B98*10%))

  3. #3
    Forum Expert Paul's Avatar
    Join Date
    02-05-2007
    Location
    Wisconsin
    MS-Off Ver
    2016/365
    Posts
    6,885
    David, couldn't you simplify this to just

    =B98*.9

    or

    =B98*90%

    Algebraically, x - .1x == .9x

  4. #4
    Registered User
    Join Date
    12-06-2004
    Location
    Eldorado, Texas
    Posts
    24
    Yes I could. Didn't think about that.

    Thanks.

+ 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. Conditional formula and results in colors
    By flyingbanana in forum Excel General
    Replies: 2
    Last Post: 06-25-2008, 12:08 PM
  2. Looking for a macro that copies a formula from column to column as I change the month
    By caliskier in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 11-18-2007, 03:32 PM
  3. pasting results of a formula as actual numbers
    By kitbit in forum Excel General
    Replies: 3
    Last Post: 11-14-2007, 09:57 AM
  4. Stopping a spinner when it's reached end of results
    By happyfingers in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 06-16-2007, 01:27 PM
  5. Sustituting formula references
    By Dave2000 in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 11-03-2006, 09:00 AM

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