0

Is anyone able to advise what's wrong with this formula: 

=IF(B3<TIMEVALUE("08:00 AM"),TIMEVALUE("08:00 AM"),B3)

I already tried to replace the , with ;, but still the same parse error. The formula does work in MS Excel, but not in Google spreadsheet.

Improve this question
1
  • Have you copied and pasted the formula from a web page into Google Sheets? Have you reviewed the spreadsheet regional settings? Are you sure that the quotation marks are straight quotes (") instead of curly quotes (“, ”)?
    – Rubén - Volunteer Moderator - ♦
    Commented Nov 14, 2017 at 20:00

1 Answer 1

Reset to default
2

There is nothing wrong with the formula so either:

  • for the sheet's locale either the language or choice of delimiter is unsuitable (or both are).

  • the formula in the sheet incorporates characters that are not displayed (and have not been copied into the OP above).

The latter tends to happen when formulae are copied out of Comments on SE (when invisible line breaks may be copied across). They can be seen if formulae are copied into Word or other suitable software.

Improve this answer

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.