You are reading a single comment by @moth and its replies.
Click here to read the full conversation.
London Fixed Gear and Single-Speed is a community of predominantly fixed gear and single-speed cyclists in and around London, UK.
This site is supported almost exclusively by donations. Please consider donating a small amount regularly.
@moth
I don't think that does the right thing: if only AT3 is blank then COUNTBLANK(C3:CG3)>0 will be true, and so will OR(anything,COUNTBLANK(C3:CG3)>0), i.e. regardless of whether AU3 = "Method C".
You could always leave AT3 out of the main countblank range and handle it seperately:
[code] NOT(AND(COUNTBLANK(C3:AS3,AU3:CG3)=0,OR(AU3="Method C",COUNTBLANK(AT3)=0))) [/code]
Or you could make Tiswas'es approach work with an IF:
[code] IF(AU3="Method C", COUNTBLANK(C3:AS3,AU3:CG3)>0, COUNTBLANK(C3:CG3)>0) [/code]