Testing Values of Cells

[none.ya]

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?

 

[Matt Lunn]

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

 

[Bob Phillips]

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]

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

 

[none.ya]

Anyone?

 

[Bob Phillips]

I already have.

--

HTH

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