Results 1 to 2 of 2

Thread: newbie looking for help

  1. #1
    Neophyte stevea99's Avatar
    Join Date
    May 2019
    Posts
    1
    Articles
    0
    Excel Version
    mac version

    newbie looking for help



    Register for a FREE account, and/
    or Log in to avoid these ads!

    Hi looking to make a formula for excel as follows

    first 40 @ 1

    40 to 80 @2

    80 to 120 @ 2.50

    120 to 160 @ 3

    how would i replica this so that I put in the number of up to 160 and it works out my bonus for work




    Thanks


  2. #2
    Conjurer alansidman's Avatar
    Join Date
    Oct 2018
    Location
    Steamboat Springs
    Posts
    144
    Articles
    0
    Excel Version
    2019
    Data Range
    A
    B
    C
    D
    E
    F
    1
    Amount
    Multiplier
    Amount
    Multiplier
    2
    50
    2
    0
    1
    3
    41
    2
    4
    81
    2.5
    5
    121
    3

    Formulas
    Data Range
    A
    B
    C
    D
    E
    F
    1
    Amount
    Multiplier
    Amount
    Multiplier
    2
    50
    =VLOOKUP(A2,$E$2:$F$5,2,TRUE)
    0
    1
    3
    41
    2
    4
    81
    2.5
    5
    121
    3

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •