SOLVED

Issue with entering formula

New Contributor

Hey when I enter a basic formula I keep getting an error code. Same issue as this 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

2 Replies
best response confirmed by Sergei Baklan (MVP)
Solution

@Cecilia1850 

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

@Hans Vogelaar 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