+ Reply to Thread
Results 1 to 6 of 6

Multiplication and Subtotal

  1. #1
    Registered User
    Join Date
    11-03-2013
    Location
    United States
    MS-Off Ver
    Excel 2010
    Posts
    25

    Multiplication and Subtotal

    Hello, Can someone tell me if my Multiplication formulas and subtotal are correct? i will give ratings.
    Attached Files Attached Files

  2. #2
    Forum Expert Ron Coderre's Avatar
    Join Date
    03-22-2005
    Location
    Boston, Massachusetts
    MS-Off Ver
    2013, 2016, O365
    Posts
    6,996

    Re: Multiplication and Subtotal

    Using your posted workbook...

    You don't need to individually reference every cell you want to sum

    Try this subtotal formula:
    E11: =SUM(E7:E10)

    and this total
    E15: =SUM(E11:E13)

    (the multiplication formulas are OK.)

    Does that help?
    Ron
    Former Microsoft MVP - Excel (2006 - 2015)
    Click here to see the Forum Rules

  3. #3
    Registered User
    Join Date
    11-03-2013
    Location
    United States
    MS-Off Ver
    Excel 2010
    Posts
    25

    Re: Multiplication and Subtotal

    yes thanks, But i mean Does my answers are Right ?

  4. #4
    Forum Expert Ron Coderre's Avatar
    Join Date
    03-22-2005
    Location
    Boston, Massachusetts
    MS-Off Ver
    2013, 2016, O365
    Posts
    6,996

    Re: Multiplication and Subtotal

    It depends on what you mean by "right". If you select cell E15 and set the number format to General, you'll see that the true value is 46.9472
    Consequently, it's up to you to decide if you round the value(s) or simple display them appropriately.
    If you need to round the calculated values...search for Excel help on the ROUND function.

  5. #5
    Registered User
    Join Date
    11-03-2013
    Location
    United States
    MS-Off Ver
    Excel 2010
    Posts
    25

    Re: Multiplication and Subtotal

    my Tax formula is correct? in other words, did i calculated correctly the Tax ?

  6. #6
    Forum Expert Ron Coderre's Avatar
    Join Date
    03-22-2005
    Location
    Boston, Massachusetts
    MS-Off Ver
    2013, 2016, O365
    Posts
    6,996

    Re: Multiplication and Subtotal

    Yes, your formula calculates 8% of the subtotal

+ 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. Replies: 1
    Last Post: 09-18-2013, 04:10 PM
  2. Replies: 8
    Last Post: 07-31-2012, 09:41 AM
  3. Subtotal - Delete zero Subtotal and prior rows that calculate to that zero Subtotal
    By Whatsherface in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 05-14-2012, 08:37 PM
  4. Replies: 3
    Last Post: 03-08-2006, 05:25 PM
  5. [SOLVED] Subtotal of Subtotal displays Grand Total in wrong row
    By Thomas Born in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 01-06-2005, 10:06 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