| 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. |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Using the IF fuction for multiple cells
Try this:
=IF(COUNTIF(A2:D2,"Yes"),"Yes","") -- Biff Microsoft Excel MVP "Mike" wrote in message ... 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. |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Using the IF fuction for multiple cells
Thanks works perfectly!!!!
Mike "T. Valko" wrote: Try this: =IF(COUNTIF(A2:D2,"Yes"),"Yes","") -- Biff Microsoft Excel MVP "Mike" wrote in message ... 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. |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Using the IF fuction for multiple cells
Hi Mike =IF(COUNTIF(A2:D2)0,"Yes","No") Strictly speaking the 0 isn't necessary, and it could be written as =IF(COUNTIF(A2:D2),"Yes","No") Make the final part "" if you want nothing to show in the cell instaed of "no" -- Roger Govier ------------------------------------------------------------------------ Roger Govier's Profile: http://www.thecodecage.com/forumz/member.php?userid=81 View this thread: http://www.thecodecage.com/forumz/sh...ad.php?t=82572 |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Using the IF fuction for multiple cells
You're welcome. Thanks for the feedback!
-- Biff Microsoft Excel MVP "Mike" wrote in message ... Thanks works perfectly!!!! Mike "T. Valko" wrote: Try this: =IF(COUNTIF(A2:D2,"Yes"),"Yes","") -- Biff Microsoft Excel MVP "Mike" wrote in message ... 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. |
| Reply |
| 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 | |||
Linear Mode
