Thread: Formula help
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
nadine nadine is offline
external usenet poster
 
Posts: 216
Default Formula help

Formula help please

Columns D to AH
If V, AG or AH has a zero - fail
but don't count blank cells, do nothing if blank

problem is getting fail, because the cells haven't been filled in yet, so
don't want it to fill fail if cells are blank, leave results column blank

Tried this: didn't work
=IF(COUNTBLANK(D5:AH5)=31,"",IF(OR(V5=0,AG5=0,AH5= 0),"Fail","Pass"))

tried this: didn't work
=IF(COUNT(V5,AG5,AH5),IF(SUM(V5,AG5,AH5)<1,"Fail", "Pass"),"")