Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Help with multiple IF
Hi
I would like to indicate a certain value in a cell if a certain value is found in the next 3 cells. This seems simple yet I have tried several tims without much success. Thanks in Advanced for your support. Tarlis |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Help with multiple IF
Hi,
Am Tue, 11 Oct 2016 03:28:34 -0700 (PDT) schrieb Tarlis Machado: I would like to indicate a certain value in a cell if a certain value is found in the next 3 cells. This seems simple yet I have tried several tims without much success. post an example of your data with the expected output. Regards Claus B. -- Windows10 Office 2016 |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Help with multiple IF
Hi Claus,
I would like to have the value "Involved" where at least 1 of the 3 scenarios have a "Yes" value. Here Scenario A | Scenario B | Scenario C | Scenario studied? Yes | Yes | No | Involved No | No | No | Not Involved No | No | Yes | Involved Thanks for your help. Regards, Tarlis Windows 7 Office 2010 |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Help with multiple IF
Hi Tarlis,
Am Tue, 11 Oct 2016 05:52:35 -0700 (PDT) schrieb Tarlis Machado: I would like to have the value "Involved" where at least 1 of the 3 scenarios have a "Yes" value. Here Scenario A | Scenario B | Scenario C | Scenario studied? Yes | Yes | No | Involved No | No | No | Not Involved No | No | Yes | Involved try in D2: =IF(COUNTIF(A2:C2,"Yes")0,"Involved","Not Involved") and copy down Regards Claus B. -- Windows10 Office 2016 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Copy range from multiple files in multiple folders to single sheet in master WB | Excel Programming | |||
Delete Blank Rows Code - Multiple Worksheets - Multiple Documents | Excel Discussion (Misc queries) | |||
macro: copy multiple workbooks to multiple tabs in single book | Excel Programming | |||
Crteating Multiple GIFS from Multiple Ranges -- need someone to test my code to see why it fails | Excel Programming | |||
view multiple files in multiple windows on multiple screens. | Excel Discussion (Misc queries) |