+ Reply to Thread
Results 1 to 3 of 3

Help Please! IF formula (i hope that's right!)

  1. #1
    KarenYM
    Guest

    Help Please! IF formula (i hope that's right!)

    I need help with what is probably relatively simple, but I probably using the
    wrong solution. Maybe it should be a look up? Basically, I need to have the
    accrual rate equal a specific amount based on the "type". i.e. = salary=16
    or hourly=8

    A B C
    type accrual rate (8) final result (rate * 12)
    1 "salary" " " (16)
    2 "salary" " " (16)
    3 "hourly" " " (8)

    All feedback is greatly appreciated.



  2. #2
    Arvi Laanemets
    Guest

    Re: Help Please! IF formula (i hope that's right!)

    B2=CHOOSE(MATCH($A2,{"salary";"hourly"},0),16,8)

    You can have up to 28 different types in array parameter (the one between
    curly braces) for MATCH, along with according responses as parameters in
    CHOOSE. The general syntax is
    =CHOOSE(MATCH(LookupValue,{Value1;Value2;...;ValueN},0),Response1,Response2,...,ResponseN)
    with N<=28

    The another possible solution:
    B2=((A2="salary")*2+(A2="hourly"))*8

    In general:
    =((A2=Value1)*X1+(A2=Value2)*X2+ ... +(A2=ValueN)*XN)*8


    --
    Arvi Laanemets
    ( My real mail address: arvi.laanemets<at>tarkon.ee )



    "KarenYM" <KarenYM@discussions.microsoft.com> wrote in message
    news:3C6A3F76-6931-46AA-A8FE-2AD652016F32@microsoft.com...
    >I need help with what is probably relatively simple, but I probably using
    >the
    > wrong solution. Maybe it should be a look up? Basically, I need to have
    > the
    > accrual rate equal a specific amount based on the "type". i.e. =
    > salary=16
    > or hourly=8
    >
    > A B C
    > type accrual rate (8) final result (rate * 12)
    > 1 "salary" " " (16)
    > 2 "salary" " " (16)
    > 3 "hourly" " " (8)
    >
    > All feedback is greatly appreciated.
    >
    >




  3. #3
    KarenYM
    Guest

    Re: Help Please! IF formula (i hope that's right!)

    Avri,
    Awesome! Someone who really knows formulas. Thanks so much. I tried both
    and they work great!
    Karen

    "Arvi Laanemets" wrote:

    > B2=CHOOSE(MATCH($A2,{"salary";"hourly"},0),16,8)
    >
    > You can have up to 28 different types in array parameter (the one between
    > curly braces) for MATCH, along with according responses as parameters in
    > CHOOSE. The general syntax is
    > =CHOOSE(MATCH(LookupValue,{Value1;Value2;...;ValueN},0),Response1,Response2,...,ResponseN)
    > with N<=28
    >
    > The another possible solution:
    > B2=((A2="salary")*2+(A2="hourly"))*8
    >
    > In general:
    > =((A2=Value1)*X1+(A2=Value2)*X2+ ... +(A2=ValueN)*XN)*8
    >
    >
    > --
    > Arvi Laanemets
    > ( My real mail address: arvi.laanemets<at>tarkon.ee )
    >
    >
    >
    > "KarenYM" <KarenYM@discussions.microsoft.com> wrote in message
    > news:3C6A3F76-6931-46AA-A8FE-2AD652016F32@microsoft.com...
    > >I need help with what is probably relatively simple, but I probably using
    > >the
    > > wrong solution. Maybe it should be a look up? Basically, I need to have
    > > the
    > > accrual rate equal a specific amount based on the "type". i.e. =
    > > salary=16
    > > or hourly=8
    > >
    > > A B C
    > > type accrual rate (8) final result (rate * 12)
    > > 1 "salary" " " (16)
    > > 2 "salary" " " (16)
    > > 3 "hourly" " " (8)
    > >
    > > All feedback is greatly appreciated.
    > >
    > >

    >
    >
    >


+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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