LinkBack URL
About LinkBacks
Hi All,
Need help with a formula for a cell that meets multiple condition.
B2 = Fail, if any cells between C4:C70 = fail and C2 = Vacant else B2 = C2
Thanks
Madison
Hi All,
Need help with a formula for a cell that meets multiple condition.
B2 = Fail, if any cells between C4:C70 = fail and C2 = Vacant else B2 = C2
Thanks
Madison
Hi,
Maybe
Formula:
=IF(AND(COUNTIF(C4:C70,"fail")>0,C2="Vacant"),"Fail",C2)
Richard Buttrey
RIP - d. 06/10/2022
If any of the responses have helped then please consider rating them by clicking the small star iconbelow the post.
Thank you Richard, that's working great.
Madison
Turns out I forgot one more criteria.
B2 = Fail, if any cells between C4:C70 = fail and C2 = Vacant else B2 = C2
and
B2 = PASS, if all cells between C4:C70 = PASS and C2 = Vacant else B2 = C2
Thanks,
Madison
anyone, much appreciated.
Both those two criteria rely on C2 being Vacant, but what's the result if C2 is something other than vacant?
Assuming that C4:C70 is either "PASS" or "fail", try this:
=IF(C2="Vacant",IF(COUNTIF(C4:C70,"fail"),"Fail","PASS"),C2)
I'm trying 63falcondude's formula now.
63falcondude's formula is working. Thanks to the both of you guys. Much appreciated. Madison.
Glad we could help.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks