Results 1 to 4 of 4

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

Threaded View

  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.

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. 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