+ Reply to Thread
Results 1 to 3 of 3

rounded value question

  1. 01-30-2014, 12:21 PM #1
    DENWARD
    DENWARD is offline
    Registered User
    Join Date
    11-08-2012
    Location
    Silver Spring, MD
    MS-Off Ver
    Excel 2010
    Posts
    23

    rounded value question

    I need a formula to act on the "rounded value" that is created by ROUND function. Currently , the formula acts on the source (or actual value). There has to be a way ! Can you assist ?

    1.75 is the actual value
    2.0 is the rounded value

    I need my formula to act on the 2.0 value.
    Reply With QuoteRegister To Reply
  2. 01-30-2014, 12:36 PM #2
    shg
    shg is offline
    Forum Expert shg's Avatar
    Join Date
    06-20-2007
    Location
    The Great State of Texas
    MS-Off Ver
    2003, 2010
    Posts
    40,678

    Re: rounded value question

    Replace each instance of the actual value in the formula with round(actual value, 0)
    Entia non sunt multiplicanda sine necessitate
    Reply With QuoteRegister To Reply
  3. 01-30-2014, 12:54 PM #3
    shg
    shg is offline
    Forum Expert shg's Avatar
    Join Date
    06-20-2007
    Location
    The Great State of Texas
    MS-Off Ver
    2003, 2010
    Posts
    40,678

    Re: rounded value question

    Cross-posted at http://www.mrexcel.com/forum/excel-q...-question.html
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. syntax for comparing a rounded number to a rounded list
    By stockgoblin42 in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 08-10-2013, 10:12 AM
  2. Datedif rounded up
    By HCBalelo in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 12-05-2012, 01:45 PM
  3. Rounded off results
    By sufirosso in forum Excel General
    Replies: 15
    Last Post: 04-18-2012, 02:42 PM
  4. [SOLVED] how do i add rounded numbers?
    By echase in forum Excel General
    Replies: 4
    Last Post: 11-12-2005, 02:45 PM
  5. IF formula question:part 100's rounded up to the next 100
    By Barb1 in forum Excel General
    Replies: 3
    Last Post: 09-19-2005, 05:05 PM

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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1