+ Reply to Thread
Results 1 to 2 of 2

how do I use SUM, SUMIF & ROUND within the same cell

Hybrid View

  1. #1
    Registered User
    Join Date
    07-26-2014
    Location
    Nottingham, UK
    MS-Off Ver
    Microsoft Office Professional 2010
    Posts
    32

    how do I use SUM, SUMIF & ROUND within the same cell

    Hi,

    I currently have this formula:

    I9 =sum(G8+H8)*D8

    e.g.
    G8 = 7.25
    H8 = 2
    D8 = £3.79
    so the I9 cell returns the answer 27.4775.

    This, however, is currency (£27.48) and therefore needs to be rounded up/down to the nearest 0.05.

    I can do this if I use a separate cell and use =ROUND(I9,2) but I want it all within the same cell.

    How do I do it so that it adds G8 & G9 together AND then multiplys that by D8 AND rounds it up/down to 2 decimal places, all within 1 cell?


    Kind regards,
    Sally

  2. #2
    Forum Expert
    Join Date
    12-11-2011
    Location
    Netherlands
    MS-Off Ver
    office 365
    Posts
    3,658

    Re: how do I use SUM, SUMIF & ROUND within the same cell

    Try this:
    =MROUND((G8+H8)*D8,0.05)
    Willem
    English is not my native language sorry for errors
    Please correct me if I'm completely wrong

+ 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: 2
    Last Post: 12-06-2014, 01:58 PM
  2. [SOLVED] How to round to nearest .01 and round down if thousands place is .005
    By dredre609 in forum Excel General
    Replies: 5
    Last Post: 09-29-2014, 11:47 AM
  3. round up in own cell
    By Tim in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 09-05-2005, 10:05 PM
  4. round up in own cell
    By Tim in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 06-19-2005, 11:05 PM
  5. [SOLVED] How do I ROUND() round off decimals of a column dataset?
    By Højrup in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 01-12-2005, 07:06 AM

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