| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Using the IF fuction for multiple cells
Can anyone help me correctly write an IF function for multiple cells? Here is
an example of what I am needing help with: A2, B2, C2, D2 are all yes or no responses. I need a formula that will tell me if anyone of these cells is "yes" then the outcome is yes. In an individual cell my formula is =IF(A2="Yes","Yes","")...this works fine but I need to expand to capture all cells. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Sumif as a fuction of If using multiple criteria | Excel Worksheet Functions | |||
| Add single fuction to end of multiple cell column | Excel Discussion (Misc queries) | |||
| multiple cell fuction results in fraction format | Excel Discussion (Misc queries) | |||
| if fuction | Excel Worksheet Functions | |||
| need a fuction that can do this (or can it be done) | Excel Worksheet Functions | |||
Threaded Mode
