Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.newusers,microsoft.public.excel.programming,microsoft.public.excel.worksheet.functions,microsoft.public.excel.worksheetfunctions
|
|||
|
|||
syntax correction
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 |
#2
Posted to microsoft.public.excel.programming,microsoft.public.excel.worksheet.functions,microsoft.public.excel.newusers
|
|||
|
|||
syntax correction
Maybe:
=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)))))) ??? Creating helper columns rather than relying on one long formula may make your logic clearer. Dave -- A hint to posters: Specific, detailed questions are more likely to be answered than questions that provide no detail about your problem. "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 |
#3
Posted to microsoft.public.excel.programming,microsoft.public.excel.worksheet.functions,microsoft.public.excel.newusers
|
|||
|
|||
syntax correction
the first part of your IF statement
=IF(AND(F8<"X",F8=""),C3-D8,IF(F8<"",C3-F8) take the And(F8<"X",F8="") then only thing that satisfys that is if F8="", so the F8<"X" is redundant now that would give you =IF(F8="",C3-D8,If(F8<"",C3-F8)) that pretty much boils down to If(F8="",C3-D8,C3-F8) Which boils down to =C3-D8 Although you might have an operator missing between that and the next statement, it isn't clear, so think you would be better of saying what is entered in each of your cells and what rules you want to apply to arrive at what. -- Regards, Tom Ogilvy "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 |
#4
Posted to microsoft.public.excel.programming,microsoft.public.excel.worksheet.functions,microsoft.public.excel.newusers
|
|||
|
|||
syntax correction
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 |
#5
Posted to microsoft.public.excel.programming,microsoft.public.excel.worksheet.functions,microsoft.public.excel.newusers
|
|||
|
|||
syntax correction
=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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Auto Correction | Excel Discussion (Misc queries) | |||
correction | Excel Discussion (Misc queries) | |||
Error correction | Excel Discussion (Misc queries) | |||
formula correction | Excel Worksheet Functions | |||
decimal correction | Excel Worksheet Functions |