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

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

KarenYM - 15 Jun 2006 05:38 GMT

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 this Message

Arvi Laanemets - 15 Jun 2006 07:02 GMT

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

Signature

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

>I need help with what is probably relatively simple, but I probably using
>the
[quoted text clipped - 11 lines]
>
> All feedback is greatly appreciated.

Reply to this Message

KarenYM - 18 Jun 2006 17:23 GMT

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

> B2=CHOOSE(MATCH($A2,{"salary";"hourly"},0),16,8)
>
[quoted text clipped - 25 lines]
> >
> > All feedback is greatly appreciated.

Reply to this Message