Expressions with 2 logical conditions?

[Jeff Galbraith]

Is it possible to create an expression that derives a value based on the combination of 2 separate properties?  I've been able to use the IF and IFS functions with varying success, but they both only appear to allow the use of one logical condition per result.  

ie:  The IF and IFS functions allow you to say: 'IF property A = "X", then use value "y".

What I'm looking for is something that says: 'IF property A = "X", AND property B = "Z", then use value "y".

I'm trying to recreate the function of a table with 2 axis, similar to the image above.  The resulting value is based on the combination of 2 other properties.  Is this possible with Expressions?

Operating system used: Mac Apple Silicon 14.5 Sonoma

[Ricardo Lopez]

I totally agree with you @furtonb .

A good practice would be to keep an internal log of notes with texts and images where we explain to our future self (or others) what we did.