Help with if function in a field's control source

[templeowls]

I was hoping to come up with a an IF statement for the below situation but I'm struggling on how to write it.

In [field 2]'s control source, I wanted the following:

If [field1] > 10, then 'yes'
If [field1] < 10, then 'no'


If [field1] is null, then null

Any suggestions? Multiple IF statements?

[June7]

The function is IIf(). Look it up. Consider Switch() or Choose().

=Switch([field1]>10, "yes", [field1]<10, "no", True, Null)

What should happen for exactly 10?

[templeowls]

That worked!!
Thanks so much