You could do it like this:
=COUNTIF($B1:$H1,">=F")=0
of ir you wanted to do inbetween a range you could use countifs like this
=COUNTIFS($B1:$H1,">=F",$B1:$H1,"<=G")=0
You could do it like this:
=COUNTIF($B1:$H1,">=F")=0
of ir you wanted to do inbetween a range you could use countifs like this
=COUNTIFS($B1:$H1,">=F",$B1:$H1,"<=G")=0
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks