2

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

3

try this:

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

instead of “ ” you need to use " "

  • 1
    You flippin genius! Thanks it’s working now – Jake Aug 9 '18 at 20:45
  • In my case I'd put single quotes instead of double quotes – wjandrea 8 hours ago

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.