| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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"),"") |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Formula help
=IF(OR(ISBLANK(V5),ISBLANK(AG5),ISBLANK(AH5)),"Pas s",IF(OR(V5=0,AG5=0,AH5=0),"Fail","Pass")
"Nadine" wrote: 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"),"") |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Formula help
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 "Sean Timmons" wrote: =IF(OR(ISBLANK(V5),ISBLANK(AG5),ISBLANK(AH5)),"Pas s",IF(OR(V5=0,AG5=0,AH5=0),"Fail","Pass") "Nadine" wrote: 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"),"") |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Formula help
So does that mean it works now?
"Nadine" wrote: 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 "Sean Timmons" wrote: =IF(OR(ISBLANK(V5),ISBLANK(AG5),ISBLANK(AH5)),"Pas s",IF(OR(V5=0,AG5=0,AH5=0),"Fail","Pass") "Nadine" wrote: 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"),"") |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Formula help
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 "Sean Timmons" wrote: So does that mean it works now? "Nadine" wrote: 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 "Sean Timmons" wrote: =IF(OR(ISBLANK(V5),ISBLANK(AG5),ISBLANK(AH5)),"Pas s",IF(OR(V5=0,AG5=0,AH5=0),"Fail","Pass") "Nadine" wrote: 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"),"") |
|
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Formula help
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") "Nadine" wrote: 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 "Sean Timmons" wrote: So does that mean it works now? "Nadine" wrote: 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 "Sean Timmons" wrote: =IF(OR(ISBLANK(V5),ISBLANK(AG5),ISBLANK(AH5)),"Pas s",IF(OR(V5=0,AG5=0,AH5=0),"Fail","Pass") "Nadine" wrote: 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"),"") |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Linear Mode
