Forum Discussion
Issue with entering formula
Hey when I enter a basic formula I keep getting an error code. Same issue as https://support.microsoft.com/en-us/office/how-to-avoid-broken-formulas-8309381d-33e8-42f6-b889-84ef6df1d586 where it doesn't recognise it. I tried using for example
=mod(row(),)=1
or
=TIME(HOUR(A2), MINUTE(A2), SECOND(A2)) - TIME(HOUR(B2), MINUTE(B2), SECOND(B2))
but none of them worked. What can I do
Do you use comma as decimal separator? If so, use semi-colon ; between the arguments of a function
=TIME(HOUR(A2); MINUTE(A2); SECOND(A2)) - TIME(HOUR(B2); MINUTE(B2); SECOND(B2))
The first formula should probably be
=MOD(ROW(), 2)=1
or
=MOD(ROW(); 2)=1
2 Replies
Do you use comma as decimal separator? If so, use semi-colon ; between the arguments of a function
=TIME(HOUR(A2); MINUTE(A2); SECOND(A2)) - TIME(HOUR(B2); MINUTE(B2); SECOND(B2))
The first formula should probably be
=MOD(ROW(), 2)=1
or
=MOD(ROW(); 2)=1
HansVogelaar Hey thank you so much. That actually solved the issue. I think in the past commas also worked. Haven't thought about trying the semi colon one.
Thanks again
