Results 1 to 7 of 7

Formula help determining amount $ per year amount from scale

Threaded View

  1. #1
    Registered User
    Join Date
    06-25-2014
    Location
    Canada
    MS-Off Ver
    2010 Pro
    Posts
    3

    Formula help determining amount $ per year amount from scale

    help!.xlsxCopie de Document remis au syndicat pour assemblée.xlsxHello,

    So I've made this table in which I have the age of my employees, amount of the 1.5% to be removed from 0 to 57 years of age (increments of 888$ per year - 57 = 888 56 = 1776 ect)
    Then I have the amounts payable from 58 till 65 (1220$ per year - 65= 1220$ 64= 2440$ ect)

    What I need is a formula that would take these amounts in consideration and apply it automaticaly to the age varying on the age one might retire on. The basis is 58 so the amounts currently in the files are for a retirement at 58. Should the person leave at 59-60-61-62-63-64 or 65 I would need to also be able to get the amounts.

    Bare with me it's all in french but here is a quick translation.

    Columns

    A
    Employee number
    B
    Name
    C
    First Name
    D
    Date of birth
    L
    Date 2
    N
    Age
    O
    Amount 0-57 1.5%
    P
    Amount 58-65 1220$
    and Q
    is where I want the formula.

    If you need additional information let me know!

    Thanks in advance!

    Copie de Document remis au syndicat pour assemblée.xlsx
    help!.xlsx
    Last edited by JBeaucaire; 06-19-2015 at 04:39 PM.

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Replies: 2
    Last Post: 11-21-2014, 09:35 AM
  2. [SOLVED] Folder has X amount of jpeg files. How to automate creating links for those X amount of fi
    By JPWRana in forum Excel Programming / VBA / Macros
    Replies: 10
    Last Post: 10-24-2013, 09:50 AM
  3. [SOLVED] In pivot match vertical row amount with the horizontal column -amount and highlight that
    By Goku in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 02-21-2013, 02:04 AM
  4. [SOLVED] Formula for amount owing subtract amount paid
    By Taperchart in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 06-04-2006, 12:55 PM
  5. Replies: 16
    Last Post: 05-04-2005, 04:26 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