=if(S,if(A,B,C)*if(D,E,F),if(M,N,O)*if(P,Q,R))

would be legitimate, so I am not sure what you mean by * are not allowed.
But you are correct that the formula posted is not clear on what the OP
wants.

--
Regards,
Tom Ogilvy


"Joel" wrote:

there isn't 1 way to fix the formular. It is not clear what you are trying
to do.

There must be a commar before each IF. * are not allow to nest IF.

Instead you want someting like

if(A=B,if(C=D,if(E=F))) for nesting the IFs

"Richard" wrote:

I wrote this function, the logics seem to ok, but there are too many logic,
as I the result I think I mess up the syntax. Can anyone correct for me?

the function is:
=IF(AND(F8<"X",F8=""),C3-D8,IF(F8<"",C3-F8)IF(AND(G8<"X",G8=""),C3-F8)*IF(G8<0,C3-G8)*IF(AND(H8<"X",H8=""),C3-G8,)IF(H8<"",C3-H8,0))

where C3 is a now() function with customed to time, and where D8 is the
beginning time for an employee. The function above time elapsed from the 1
break to 3 break. Each time a break is entered now() function or C3 has to
minus the time starting a break, then this equal to time elapsed since last
break..thanks