I'm new to complex formuls, this formula returns the error, if i remove any of the if lines it works ok, i can't seem to combine it all together.
this is a helper cell in a table, it shows 1 if error or 10 if ok, then i use conditional formatting icon set to show a cross or tick depending on the result.
If it's the file type how can i fix that - SaveAs what ?
It's checking for cells that have an error, are blank, H8<=0 J8< 0.04097, if times are between 6:30am and 6:30pm, and if those times are a multiple of 15 minutes
=IF(OR(ISERROR(H8),ISERROR(I8),ISERROR(O8),ISERROR(P8)),1,
IF(OR(ISBLANK(A8),ISBLANK(C8),ISBLANK(D8),ISBLANK(E8),ISBLANK(F8)),1,
IF(OR(MOD(MINUTE(C8),15)>0,MOD(MINUTE(D8),15)>0,MOD(MINUTE(E8),15)>0,MOD(MINUTE(F8),15)>0),1,
IF(OR((H8)<=0,(J8)>0.04097),1,
IF(AND((C8)<0.270833333,(C8)>0.770833334),1,
IF(AND((D8)<0.270833333,(D8)>0.770833334),1,
IF(AND((E8)<0.270833333,(E8)>0.770833334),1,
IF(AND((F8)<0.270833333,(F8)>0.770833334),1,10))))))))
Bookmarks