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
  • In my case I'd put single quotes instead of double quotes
    – wjandrea
    Dec 11, 2019 at 22:18

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

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