+ Reply to Thread
Results 1 to 4 of 4

ROUND fuction yielding the same value

  1. #1
    Registered User
    Join Date
    07-22-2022
    Location
    Washington, USA
    MS-Off Ver
    Office 10
    Posts
    13

    ROUND fuction yielding the same value

    Hello

    I'm a new Excel user and I'm having an issue where my ROUND function is yielding the same numeric value for each cell. I can double click into each cell and then the formula is correct. I'm sure this is a quick formatting issue but I'm unsure how to look for a fix.

    Thanks

  2. #2
    Forum Guru
    Join Date
    09-10-2017
    Location
    Chippenham, England
    MS-Off Ver
    365
    Posts
    15,112

    Re: ROUND fuction yielding the same value

    Make sure that calculation is set to automatic.
    It's on the formula tab under Calculation options

  3. #3
    Registered User
    Join Date
    07-22-2022
    Location
    Washington, USA
    MS-Off Ver
    Office 10
    Posts
    13

    Re: ROUND fuction yielding the same value

    I feel dumb....but thank you Fluff13!!

  4. #4
    Forum Guru
    Join Date
    09-10-2017
    Location
    Chippenham, England
    MS-Off Ver
    365
    Posts
    15,112

    Re: ROUND fuction yielding the same value

    Glad to help & thanks for the feedback.

+ 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. [SOLVED] If then else statement yielding blanks
    By exceluniprojecthelp in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 08-22-2021, 11:34 PM
  2. yielding a number of days between two dates
    By mjohn99 in forum Excel General
    Replies: 3
    Last Post: 07-15-2019, 11:01 AM
  3. VLOOKUP not yielding the correct data
    By bradleyandrewdavis in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 04-29-2015, 06:51 PM
  4. Yielding to others while macro is running?
    By vientito in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 12-20-2013, 02:14 PM
  5. Following UDF is NOT yielding result. Could you please where the problem is?
    By Bibek.Bhattacharyya in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 03-07-2013, 09:06 AM
  6. formula not yielding value from vlookup
    By vislavti in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 10-31-2011, 01:28 PM
  7. Sensitivity analysis yielding same output in all cells
    By wmfinance in forum Excel General
    Replies: 1
    Last Post: 07-01-2010, 03:56 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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1