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.
Solved! Go to Solution.
@mmytrunec hey nothing wrong with your syntax. -1 would be indicating true, 0 would indicate false. It's just another way to display it!
Thank you kindly @BS_THE_ANALYST . Is there a way I can adjust the output so that it displays "TRUE" and "False" instead of the numbers?
@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
Converting the datatype to "BOOL" for the below formula generated the desired outcome (image 1). Updating the function so that the "or" was within one IF function also generated the desired outcome (image 2). Thank you all for the assistance!