Not sure why my formula isn't working

It’s super simple but yet returns a formula parse error

=If(A19>A22, “no”, “yes”)

Value of A19 is 30 and the value of A22 is 0

1 Answer 1


try this:

=IF(A19>A22; "no"; "yes")

instead of “ ” you need to use " "

  • 2
    You flippin genius! Thanks it’s working now
    – Jake
    Aug 9, 2018 at 20:45
  • 1
    In my case I'd put single quotes instead of double quotes
    – wjandrea
    Dec 11, 2019 at 22:18
  • @wjandrea: yep, same here. Why Sheets won't accept single quotes as well as double quotes, when JavaScript does just that, is a bit mystifying. May 11 at 0:12

Your Answer

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

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