Formula in Numbers shows the syntax error.

Question

Level 1

8 points

Formula in Numbers shows the syntax error.

When I use the hours to mulitply it with a specific number, after converting it to decimal using DUR2HOURS, shows the syntax error.

[Re-Titled by Moderator]

iPhone 7, iOS 13

Posted on Oct 29, 2019 2:05 AM

Reply

Answer 1

Top-ranking reply

ashwinraju Author

Level 1

8 points

Oct 30, 2019 1:09 AM in response to t quinn

Thank you for the quick reply, but I figured it out. The problem was the currency was in Euros and in it, the decimals are commas and I was putting the decimal point instead of it. For example, I was entering 12.45 instead of 12,45.

Reply

Answer 2

t quinn

Level 5

7,050 points

Oct 29, 2019 6:44 AM in response to ashwinraju

Hi ashwinraju,

A syntax error could be as simple as a misplaced comma. It could be a number of things.

A screenshot showing the formula along with a copy of the formula would give us something to work with.

quinn

Reply

Answer 3

t quinn

Level 5

7,050 points

Oct 30, 2019 7:20 AM in response to ashwinraju

Hi ashwinraju,

So, a misplaced period. Glad you figured it out.

quinn

Reply