Question: I have this part of query: 

```
IF(orders = NULL OR orders = '', "value1', 'value2')

```

which works with empty cells but not with null ones, any help?
When it's NULL it doesn't make anything but when it's '' it runs the query

Answer: 
It's spelled `orders is NULL` (not `orders = NULL`).
You have to use 

```
IF(orders IS NULL OR orders = '', 'value1', 'value2')

```

instead