Array If formula
Assuming you mean that *every* cell in the range must contain "Yes".
Array entered** :
=IF(AND($AC$136:$AC$146="Yes"),"Yes", "No")
** array formulas need to be entered using the key combination of
CTRL,SHIFT,ENTER (not just ENTER). Hold down both the CTRL key and the SHIFT
key then hit ENTER.
--
Biff
Microsoft Excel MVP
" wrote in message
...
I can't get this to work:
{=IF(($AC$136:$AC$146="Yes"),"Yes", "No")}
I want to return the header of data to return Yes once all the details
have been flipped to yes.
Thoughts.
|