Results 1 to 5 of 5

How to formulate a cell based on the table of contribution

Threaded View

  1. #1
    Forum Contributor
    Join Date
    01-16-2012
    Location
    Manila, Philippines
    MS-Off Ver
    Excel 2007
    Posts
    105

    How to formulate a cell based on the table of contribution

    Hi

    Need help to correct my formula. I try using this formula in order to plot the contribution of the employer based on the salary of an employee:
    =INDEX(contri table!$F$5:$F$33,MATCH($A4,TRIM(LEFT(contri table!$B$5:$B$33,FIND("-",contri table!$B$5:$B$33)-1))*1,1)) but it always gives me a #N/A result, what seems to be problem? Hope you could enlighten me bout this.


    Thank you.
    Attached Files Attached Files
    Last edited by gerard_gonzales33; 11-20-2013 at 02:31 AM. Reason: does not comply with rule 1

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Excel 2007 : need help correcting a formula
    By berk21 in forum Excel General
    Replies: 2
    Last Post: 03-08-2010, 07:36 PM
  2. [SOLVED] need help in correcting the formula
    By JE McGimpsey in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 09-06-2005, 07:05 AM
  3. [SOLVED] need help in correcting the formula
    By JE McGimpsey in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 09-06-2005, 04:05 AM
  4. need help in correcting the formula
    By azmi in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 09-06-2005, 03:05 AM
  5. [SOLVED] need help in correcting the formula
    By azmi in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 09-06-2005, 01:05 AM

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