IFS function: Evaluates multiple conditions and returns a value that corresponds to the first true condition. Syntax: IFS(condition1, value1, condition2, value2, …) where condition1 - The first condition to be evaluated. value1 - The returned value if condition1 is TRUE. condition2, value2, … - Additional conditions and values if the first one is evaluated to be false. You can evaluate multiple conditions using the IFS function. For example, IFS(Age > 60, "Old", Age > 18, "Adult", Age >=12, "Teenager", "Kid"). If you would like to calculate the rent based on the value entered for the short answer question "Rent/Mortgage" and the answer selected for the multiple choice question "Is this monthly or pa?" with "Monthly", "Yearly" as the two answer choices, then you can use the IFS function as show below. IFS(Is this monthly or pa? == "Monthly", Rent/Mortgage * 12, Is this monthly or pa? == "Yearly", Rent/Mortgage) Add values You can use the SUM() function to add the answers (which is a number) for different questions. SUM( question#1, question#2, question#3 ) where question#1, question#2, question#3 are questions you want to add. You must type @ and select the required field from the list to include them in the formula. Please try this and confirm.