Formula help

  • Thread starter Thread starter Nadine
  • Start date Start date
N

Nadine

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"),"")
 
=IF(OR(ISBLANK(V5),ISBLANK(AG5),ISBLANK(AH5)),"Pass",IF(OR(V5=0,AG5=0,AH5=0),"Fail","Pass")
 
Close but no, still getting results filled in when there is blank cells in v,
ag, ah

oh got it, had to change the first part to do nothing leave blank

=IF(OR(ISBLANK(V5),ISBLANK(AG5),ISBLANK(AH5)),"",
IF(OR(V5=0,AG5=0,AH5=0),"Fail","Pass")


Thanks
 
So does that mean it works now?

Nadine said:
Close but no, still getting results filled in when there is blank cells in v,
ag, ah

oh got it, had to change the first part to do nothing leave blank

=IF(OR(ISBLANK(V5),ISBLANK(AG5),ISBLANK(AH5)),"",
IF(OR(V5=0,AG5=0,AH5=0),"Fail","Pass")


Thanks
Click to expand...
 
Nope, thought it was, applied it now to a workbook that has data and results
are invalid

IF- V, AG, AH - is blank do nothing, leave results cell blank

if - V or AG or AH - has a Zero - then show FAIL
 
So if V is blank bu AV has a value you want PASS?

In that case,

=IF(AND(ISBLANK(V5),ISBLANK(AG5),ISBLANK(AH5)),"",
IF(OR(V5=0,AG5=0,AH5=0),"Fail","Pass")
 
Back
Top