What's the criteria?
If you want to trigger the TRUE value if the range contains any "x" value, for example, try this
=IF(COUNTIF(range,"x")>0,TRUE,FALSE)
What's the criteria?
If you want to trigger the TRUE value if the range contains any "x" value, for example, try this
=IF(COUNTIF(range,"x")>0,TRUE,FALSE)
Audere est facere
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks