Testing Values of Cells

I am trying to test the values of cells in two columns of data and
based on the contents of these values insert a value into a third
column.

For example:

If the value in Cell F2 = 'A' AND the value in Cell G2 = 1 THEN insert
the value 'V1' into Cell H2

If the value in Cell F2 = 'A' AND the value in Cell G2 = 2 THEN insert
the value 'V3' into Cell H2

etc.

Can anyone please help me with this?

Hi,

There are a few ways to accomplish this depending on the level of complexity.
Could you post the full range of cominations/results?

Thanks,
Matt

"none.ya@bidness.com" wrote:

>
> I am trying to test the values of cells in two columns of data and
> based on the contents of these values insert a value into a third
> column.
>
> For example:
>
> If the value in Cell F2 = 'A' AND the value in Cell G2 = 1 THEN insert
> the value 'V1' into Cell H2
>
> If the value in Cell F2 = 'A' AND the value in Cell G2 = 2 THEN insert
> the value 'V3' into Cell H2
>
> etc.
>
> Can anyone please help me with this?
>

I am pulling a dataset from a database into a worksheet, so the amount
of data depends on imput parameters from the user. But, here are the
combinations:



Value1 Value2 Value to Insert

New Trans Abandoned Customer opt out
Regular Abandoned in queue Abandoned
Regular Abandoned while ringing agent Abandoned
Conf/Trans All other cases Transfer to CCT
Regular All other cases Handled by CSR
Transfer All other cases Transfer to CCT
Conference Call disconnected by agent Handled by CSR
Regular Call disconnected by agent Handled by CSR
Emergency Call disconnected by agent Handled by CSR
Conference Call disconnected by caller Handled by CSR
Regular Call disconnected by caller Handled by CSR
Conf/Trans Terminated by transfer Transfer to extension













On Tue, 19 Jul 2005 12:34:04 -0700, Matt Lunn
<MattLunn@discussions.microsoft.com> wrote:

>Hi,
>
>There are a few ways to accomplish this depending on the level of complexity.
>Could you post the full range of cominations/results?
>
>Thanks,
>Matt
>
>"none.ya@bidness.com" wrote:
>
>>
>> I am trying to test the values of cells in two columns of data and
>> based on the contents of these values insert a value into a third
>> column.
>>
>> For example:
>>
>> If the value in Cell F2 = 'A' AND the value in Cell G2 = 1 THEN insert
>> the value 'V1' into Cell H2
>>
>> If the value in Cell F2 = 'A' AND the value in Cell G2 = 2 THEN insert
>> the value 'V3' into Cell H2
>>
>> etc.
>>
>> Can anyone please help me with this?
>>

H2: =IF(F2="A",IF(G2=1,"V1",IF(G2=2,"V3","")),"")

--

HTH

RP
(remove nothere from the email address if mailing direct)


<none.ya@bidness.com> wrote in message
news:ffkqd1totfiqjfv631cpk8qkd5dc2ootv3@4ax.com...
>
> I am trying to test the values of cells in two columns of data and
> based on the contents of these values insert a value into a third
> column.
>
> For example:
>
> If the value in Cell F2 = 'A' AND the value in Cell G2 = 1 THEN insert
> the value 'V1' into Cell H2
>
> If the value in Cell F2 = 'A' AND the value in Cell G2 = 2 THEN insert
> the value 'V3' into Cell H2
>
> etc.
>
> Can anyone please help me with this?

Anyone?

I already have.

--

HTH

RP
(remove nothere from the email address if mailing direct)


<none.ya@bidness.com> wrote in message
news:salsd15dd8tjvpn7sv1pik5lkn4qhch5cr@4ax.com...
> Anyone?
>