View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Mike Mike is offline
external usenet poster
 
Posts: 3,101
Default 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.