If output returns "-1" instead of text value specified

Question

I'm solving a weekly challenge and my IF function output is "-1" or "0" when it should display "True" or" False". I'm attempting to generate a column that will show "True" if the "Type" column displays "Burger" or "Pizza" and will display "False" if the type column is a different result.

Can anyone advise if there is an issue with my syntax?

I've attempted the same formula using IFTHEN, and IIF and neither generates the desired output.

BS_THE_ANALYST · Accepted Answer

@mmytrunec I'd just advise looking at your logic again:

binu_acs · Accepted Answer

@mmytrunec Change the datatype to Bool to see the values True or False

BS_THE_ANALYST · Accepted Answer

@mmytrunec my advise would be to only use one IF statement per formula box i.e:

if you want to add more checks, utilise the ELSEIF statement inside your IF statement, i'll show an example below this:

Have a read through the statement above, and check the output. Hopefully that clears things up for you @mmytrunec . Any questions let me know.
BS