Results 1 to 2 of 2

Multiple-Sheet Workbook Management

Threaded View

  1. #1
    Registered User
    Join Date
    10-05-2014
    Location
    ct
    MS-Off Ver
    2013
    Posts
    26

    Multiple-Sheet Workbook Management

    Hey everyone Ive been working hard on this homework and I can't figure out step 12.
    STEP 12:Enter a 3-D formula in cell C3 on the October worksheet that calculates the overall percentage of total Sunday Orchestra Front tickets sold based on the total available Orchestra Front seating. The 3-D formula must perform several internal calculations, avoid raw numbers, and use an appropriate mix of relative and mixed references to derive the correct percentage. Format the result with Percent Style. The result is 100%, based on the sum of the Sunday Orchestra Front tickets sold divided by the total available tickets for all four weeks. Copy the formula to the remaining cells in the range C3:G6.

    What i'm having problem is how to calculate the percentage. I have always had problem with converting anything to percentage. I try to look for a formula but i'm not having any luck. Can some one help me please.

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Create An All In One Performance Management Workbook
    By pringle1987 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 06-24-2014, 04:54 AM
  2. [SOLVED] Consolidate Data from 1 Range on 1 Sheet in Multiple Workbooks to Master Workbook Sheet
    By Jennasis in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 07-10-2013, 06:11 AM
  3. Hotel-Management like sheet help!
    By Tabris in forum Excel General
    Replies: 0
    Last Post: 02-14-2012, 08:25 PM
  4. Sheet Management - Protected Workbook Structure
    By neodjandre in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 10-26-2007, 07:38 AM
  5. Sheet Management
    By mesh1o in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 10-02-2007, 02:12 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