Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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"),"") |