true/false expression help needed

[#1]

Can someone help me with a true/false expression? I need a field that gives me a Y or N.

I have some products and if it equals a certain value/text, I want it to say yes and if not, N.

• Coffee = 4
• Tea - Rare

For example:

If coffee = 4 then I want the field to say Y

If coffee do not equal 4, then I want the field to say N

or

If tea = 'Rare' then  Y

If tea does not equal 'Rare" then N

I am very new to QV. Thanks in advance.

[jerem1234 · Accepted solution]

Use an if statement like:

if(Coffee =4, 'Y', 'N')

if(Tea = 'Rare', 'Y', 'N')

Hope this helps!

[#3]

Thanks!!