Google sheets formula returning “Formula parse error”

Question

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

user0 · Accepted Answer · 2018-08-15 20:46:16Z

4

try this:

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

instead of “ ” you need to use " "

answered Aug 9, 2018 at 20:42

user0

25.8k8 gold badges48 silver badges77 bronze badges

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.
– Dan Dascalescu
May 11 at 0:12

Add a comment |

1 Answer 1