Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Funtion multi conditions
How could I put up a IF function with multi-conditions? Y for "Meets", "Mostly Meet" and "Exceeds" N for "Not Meet" and "unable to assess" No Info for no content in cell **************** Meets Y Mostly Meet Y Exceeds Y No Info Not Meet N Unable to assess N Meets Y No Info Not Meet N **************** Thanks, Aline -- Aline |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Funtion multi conditions
You could use an AND function along with IF.
=IF(AND(B1="Y",B2="Y",B3="Y"),"True","False") Not sure what specifics you want. Regards, Paul -- "Aline" wrote in message ... How could I put up a IF function with multi-conditions? Y for "Meets", "Mostly Meet" and "Exceeds" N for "Not Meet" and "unable to assess" No Info for no content in cell **************** Meets Y Mostly Meet Y Exceeds Y No Info Not Meet N Unable to assess N Meets Y No Info Not Meet N **************** Thanks, Aline -- Aline |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Funtion multi conditions
Hi,
How to write function on the column B according the information on the column A? On the column B: it shows Y if "Meets" or "Mostly Meet" or "Exceeds" on the column A it shows N if "Not Meet" or "unable to assess" on the column A it shows No Info if the cell is empty on the column A column A column B Meets Y Mostly Meet Y Exceeds Y No Info Not Meet N Unable to assess N Meets Y No Info Not Meet N Thanks, Aline -- Aline "PCLIVE" wrote: You could use an AND function along with IF. =IF(AND(B1="Y",B2="Y",B3="Y"),"True","False") Not sure what specifics you want. Regards, Paul -- "Aline" wrote in message ... How could I put up a IF function with multi-conditions? Y for "Meets", "Mostly Meet" and "Exceeds" N for "Not Meet" and "unable to assess" No Info for no content in cell **************** column A column B Meets Y Mostly Meet Y Exceeds Y No Info Not Meet N Unable to assess N Meets Y No Info Not Meet N **************** Thanks, Aline -- Aline |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Funtion multi conditions
Ok.
=IF(OR(A1={"Meets","Mostly Meet","Exceeds"}),"Y",IF(OR(A1={"Not Meet","unable to assess"}),"N","No Info")) HTH, Paul -- "Aline" wrote in message ... Hi, How to write function on the column B according the information on the column A? On the column B: it shows Y if "Meets" or "Mostly Meet" or "Exceeds" on the column A it shows N if "Not Meet" or "unable to assess" on the column A it shows No Info if the cell is empty on the column A column A column B Meets Y Mostly Meet Y Exceeds Y No Info Not Meet N Unable to assess N Meets Y No Info Not Meet N Thanks, Aline -- Aline "PCLIVE" wrote: You could use an AND function along with IF. =IF(AND(B1="Y",B2="Y",B3="Y"),"True","False") Not sure what specifics you want. Regards, Paul -- "Aline" wrote in message ... How could I put up a IF function with multi-conditions? Y for "Meets", "Mostly Meet" and "Exceeds" N for "Not Meet" and "unable to assess" No Info for no content in cell **************** column A column B Meets Y Mostly Meet Y Exceeds Y No Info Not Meet N Unable to assess N Meets Y No Info Not Meet N **************** Thanks, Aline -- Aline |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Funtion multi conditions
Thank you very much, Paul.
It works! -- Aline "PCLIVE" wrote: Ok. =IF(OR(A1={"Meets","Mostly Meet","Exceeds"}),"Y",IF(OR(A1={"Not Meet","unable to assess"}),"N","No Info")) HTH, Paul -- "Aline" wrote in message ... Hi, How to write function on the column B according the information on the column A? On the column B: it shows Y if "Meets" or "Mostly Meet" or "Exceeds" on the column A it shows N if "Not Meet" or "unable to assess" on the column A it shows No Info if the cell is empty on the column A column A column B Meets Y Mostly Meet Y Exceeds Y No Info Not Meet N Unable to assess N Meets Y No Info Not Meet N Thanks, Aline -- Aline "PCLIVE" wrote: You could use an AND function along with IF. =IF(AND(B1="Y",B2="Y",B3="Y"),"True","False") Not sure what specifics you want. Regards, Paul -- "Aline" wrote in message ... How could I put up a IF function with multi-conditions? Y for "Meets", "Mostly Meet" and "Exceeds" N for "Not Meet" and "unable to assess" No Info for no content in cell **************** column A column B Meets Y Mostly Meet Y Exceeds Y No Info Not Meet N Unable to assess N Meets Y No Info Not Meet N **************** Thanks, Aline -- Aline |
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Funtion multi conditions
You're welcome.
-- "Aline" wrote in message ... Thank you very much, Paul. It works! -- Aline "PCLIVE" wrote: Ok. =IF(OR(A1={"Meets","Mostly Meet","Exceeds"}),"Y",IF(OR(A1={"Not Meet","unable to assess"}),"N","No Info")) HTH, Paul -- "Aline" wrote in message ... Hi, How to write function on the column B according the information on the column A? On the column B: it shows Y if "Meets" or "Mostly Meet" or "Exceeds" on the column A it shows N if "Not Meet" or "unable to assess" on the column A it shows No Info if the cell is empty on the column A column A column B Meets Y Mostly Meet Y Exceeds Y No Info Not Meet N Unable to assess N Meets Y No Info Not Meet N Thanks, Aline -- Aline "PCLIVE" wrote: You could use an AND function along with IF. =IF(AND(B1="Y",B2="Y",B3="Y"),"True","False") Not sure what specifics you want. Regards, Paul -- "Aline" wrote in message ... How could I put up a IF function with multi-conditions? Y for "Meets", "Mostly Meet" and "Exceeds" N for "Not Meet" and "unable to assess" No Info for no content in cell **************** column A column B Meets Y Mostly Meet Y Exceeds Y No Info Not Meet N Unable to assess N Meets Y No Info Not Meet N **************** Thanks, Aline -- Aline |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Multi Column Sum and conditions | Excel Worksheet Functions | |||
SUMPRODUCT + multi conditions | Excel Worksheet Functions | |||
Multi-conditions with SUMPRODUCT and COUNTIF | Excel Worksheet Functions | |||
How to calculate values in multiple values with multi conditions | Excel Worksheet Functions | |||
how can I paste multi-line/multi-paragraph data into ONE cell? | Excel Discussion (Misc queries) |