Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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? |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Testing Values of Cells
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 " 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? |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Testing Values of Cells
H2: =IF(F2="A",IF(G2=1,"V1",IF(G2=2,"V3","")),"")
-- HTH RP (remove nothere from the email address if mailing direct) wrote in message ... 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? |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Testing Values of Cells
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 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 " 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? |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
Testing Values of Cells
Anyone?
|
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
Testing Values of Cells
I already have.
-- HTH RP (remove nothere from the email address if mailing direct) wrote in message ... Anyone? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Testing Cells | New Users to Excel | |||
HELP, PLEASE - Testing Multiple Values | Excel Discussion (Misc queries) | |||
IF function....testing against values in multiple cells | Excel Worksheet Functions | |||
Testing a string array for any values | Excel Programming | |||
Testing cell values... | Excel Programming |