+ Reply to Thread
Results 1 to 8 of 8

Quotient formula help

Hybrid View

  1. #1
    Forum Expert newdoverman's Avatar
    Join Date
    02-07-2013
    Location
    Port Dover, Ontario, Canada
    MS-Off Ver
    2010
    Posts
    10,330

    Re: Quotient formula help

    I have unscrambled your merged cells as well as I can.
    I found the errors in the Yellow area and they were do mainly because the VLOOKUP values were not in order and that is necessary for the VLOOKUP using TRUE. I changed that to False (0).

    After the unmerging of the cells, the ranges were no longer correct...if they were correct in the first place.

    Maybe this will help you out.
    Attached Files Attached Files
    <---------If you like someone's answer, click the star to the left of one of their posts to give them a reputation point for that answer.
    Ron W

+ 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] Quotient system formula for league standings
    By iamreese in forum Excel Formulas & Functions
    Replies: 14
    Last Post: 10-27-2012, 09:37 PM
  2. Quotient and Percentages
    By TomFoolery in forum Excel General
    Replies: 3
    Last Post: 01-10-2011, 02:52 PM
  3. Quotient errors
    By dknowles1234 in forum Excel General
    Replies: 2
    Last Post: 12-29-2010, 05:28 PM
  4. Quotient Whole Number ONLY?
    By SRS-Worker in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 07-02-2007, 04:17 PM
  5. [SOLVED] Is there a quotient function in VBA that's like Mod
    By WannaBeExceller in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 02-01-2006, 05:15 PM
  6. [SOLVED] Excel QUOTIENT ; That's the matter with the formula ......
    By tkt_tang@hotmail.com in forum Excel General
    Replies: 10
    Last Post: 12-28-2005, 11:50 PM
  7. How do I set a mimimum quotient value?
    By Robert in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 01-19-2005, 04:06 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