Results 1 to 10 of 10

making cells in tab2 = cells in tab1 in same workbook

Threaded View

  1. #6
    Registered User
    Join Date
    06-08-2011
    Location
    Pennsylvania
    MS-Off Ver
    Excel 2007
    Posts
    23

    Re: making cells in tab2 = cells in tab1 in same workbook

    Hi Teylyn, Here is the file unprotected for:

    Now I have a Major issue. By law we are required to show the asbestos fibers found. So, if we find 5 1/2, we must show it as 5.5 which I am in tab QA-QC cell B17 for test #1 and G17 for test #2. The fibers are the divided by the Fields in this case 100. We must show it as 5.5/100 in cell C21 for test #1 and C22 for test #2, but it is rounding up to 6. We must do it as and show it as 5.5/100. That infomation needs to be shown in tab "View report as well. I have added a new copy of the file with the fixes you suggested and I entered 5.5 for test 1 and 7.5 for test 2 so you can see what I mean.

    Thanks

Thread Information

Users Browsing this Thread

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

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