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.
|