+ Reply to Thread
Results 1 to 4 of 4

((Solved)) ROUND , ROUNDUP , ROUNDOF , IF mix formula help !!!

  1. #1
    Registered User
    Join Date
    03-12-2016
    Location
    mUMBAI
    MS-Off Ver
    2016
    Posts
    3

    ((Solved)) ROUND , ROUNDUP , ROUNDOF , IF mix formula help !!!

    help :

    need a formula for round , roundoff or roundup , if

    eg:

    99.763
    99.722
    99.82
    99.716

    i need ans as

    99.765
    99.720
    99.82
    99.715

    roundoff must be to the nearest of 3rd decimal

    help plzzzz
    Last edited by mihir777; 03-12-2016 at 02:42 PM.

  2. #2
    Forum Guru samba_ravi's Avatar
    Join Date
    07-26-2011
    Location
    Hyderabad, India
    MS-Off Ver
    Excel 2021
    Posts
    8,914

    Re: ROUND , ROUNDUP , ROUNDOF , IF mix cormula help !!!

    IF YOUR DATA STARTS FROM A1 use below formula
    Please Login or Register  to view this content.
    Samba

    Say thanks to those who have helped you by clicking Add Reputation star.

  3. #3
    Forum Guru
    Join Date
    02-27-2016
    Location
    Vietnam
    MS-Off Ver
    2016
    Posts
    5,923

    Re: ROUND , ROUNDUP , ROUNDOF , IF mix cormula help !!!

    Or try this: =MROUND(A1,0.005)

  4. #4
    Forum Expert José Augusto's Avatar
    Join Date
    10-29-2014
    Location
    Portugal
    MS-Off Ver
    2013-2016
    Posts
    3,329

    Re: ROUND , ROUNDUP , ROUNDOF , IF mix cormula help !!!

    Or you can use
    Formula: copy to clipboard
    Please Login or Register  to view this content.

+ 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. Help! Roundup/round down depending on cell value
    By nicolam_83 in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 02-17-2016, 02:37 PM
  2. Replies: 2
    Last Post: 12-06-2014, 01:58 PM
  3. [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
  4. [SOLVED] Round, Roundup, Rounddown or something else????
    By PERE in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 09-11-2013, 09:14 AM
  5. Using ROUNDUP and a Minimum value (that doesn't round) in the same function.
    By Stahlfeder in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 12-13-2012, 06:43 PM
  6. [SOLVED] Roundup or Ceiling Function to round to a specific number
    By Angie33 in forum Excel General
    Replies: 18
    Last Post: 06-29-2006, 12:50 PM
  7. [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

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