Referencing Two Variables within a Formula

Questions and Help
1

Hi Team,

I am trying to create a property expense calculator.

I am trying to reference across two variables as well.

So for example: (variables italicized)
If the cosmetic condition of the property is marked as "touch up" and the property type is marked "single family" then it will input 3000. Whereas... if the cosmetic condition is (still) "touch up" BUT property type is marked as "multifamily" then it will input 5000

Here is the beginning of my formula, just to give you an idea of what I mean:
image
-- How do I go about joining two variables for an input?

Thank you very much :grinning:

2

I believe I may have just answered my own silly question. I just have to use "and" in between the variables that I want to reference. Hopefully this helps someone else!

3 Likes