+ Reply to Thread
Results 1 to 4 of 4

One spreadsheet - Same Data - in two different tabs - slightly different results

  1. #1
    Forum Contributor
    Join Date
    06-03-2009
    Location
    Phoenix, Az
    MS-Off Ver
    MS Office 365
    Posts
    145

    One spreadsheet - Same Data - in two different tabs - slightly different results

    Hello folks - I have a unique situation that I need assistance with.
    I work with a spreadsheet at my job that takes percentages of production for our company based on different buildings.
    On the spreadsheet that I have for production month of October, I get 0.509%.

    That same data on a different part of the spreadsheet with the same formula and even set to carry out the percentage to 3 digits is giving me a result of 0.518%.

    Does anyone have any idea as why this is happening?

    Any suggestions on how to fix it would be appreciated.

    Thank you.
    Dave

  2. #2
    Forum Expert ben_hensel's Avatar
    Join Date
    01-26-2012
    Location
    Northeast USA
    MS-Off Ver
    Office 365
    Posts
    2,043

    Re: One spreadsheet - Same Data - in two different tabs - slightly different results

    Off hand:
    1) They aren't actually the same formula
    2) They don't refer to the same data

    More than that would need an example to look at.

  3. #3
    Forum Contributor
    Join Date
    06-03-2009
    Location
    Phoenix, Az
    MS-Off Ver
    MS Office 365
    Posts
    145

    Re: One spreadsheet - Same Data - in two different tabs - slightly different results

    Ben - figure it out. You were right - the data was not the same. I did not notice someone played with another part of my spreadsheet. Thank you for the help.
    Dave

  4. #4
    Forum Contributor arlu1201's Avatar
    Join Date
    09-09-2011
    Location
    Bangalore, India
    MS-Off Ver
    Excel 2003 & 2007
    Posts
    19,167

    Re: One spreadsheet - Same Data - in two different tabs - slightly different results

    If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED. Thanks.
    If I have helped, Don't forget to add to my reputation (click on the star below the post)
    Don't forget to mark threads as "Solved" (Thread Tools->Mark thread as Solved)
    Use code tags when posting your VBA code: [code] Your code here [/code]

+ 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. Slightly incorrect formula results
    By ianpwilliams in forum Excel Formulas & Functions
    Replies: 9
    Last Post: 05-06-2013, 05:04 PM
  2. [SOLVED] Staff Monitoring results that creates a new workbook of data with tabs per employee
    By tally2830 in forum Excel Programming / VBA / Macros
    Replies: 11
    Last Post: 01-25-2013, 12:11 PM
  3. Replies: 0
    Last Post: 11-21-2012, 02:12 PM
  4. Copy pie chart into new tabs, and show the results from data on those tabs
    By Sydney Lee in forum Excel - New Users/Basics
    Replies: 2
    Last Post: 05-23-2012, 07:50 PM
  5. Sales Spreadsheet- create results tabs
    By esuhcs in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 03-06-2012, 05:37 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