Consider using an IIF clause. That takes the form
The logical test is anything that results in a boolean result, it can be as simple or complex as you require. Use bracketing to group elements if the same logic branch together along with AND / Or / NOT keywords.
iif(<logical test>, <expression if True>, <expression if false>)
The result of the logic test determines which expression to use.
You can use compound IIF statements to handle complex requirements. Eg
Iif(gender = 'm', iif (..., T,F),f)
Be warned debugging compound IIF'S is a pain.
Search for details if IIF on line
I'd rather be riding on the Tiger 800 or the Norton