ContributionsMost RecentMost LikesSolutionsRe: Using IF to test multiple conditionsI will try that out and let you know, thanks for the feedback!Re: Using IF to test multiple conditionsI tried that, but because the values of the "N/A" fields vary (some are worth 2, some worth 5,etc.), and there are 7 of them, once the first condition is met, the form calculates the % based on the Total Value associated with that "N/A" condition and none of the others are calculated. What I need is to calculate the Total Value based on the combination of any of theconditions being true. Not sure it's even doable at this point :( Using IF to test multiple conditionsI am building a scorecard where if the value of a field changes to "N/A", I need the total to be divided by a different value (ie: total value - value of field that is set to "N/A"). However, I need the formula to first check if ANY of these 7 fields has a value of N/A, then subtract the values of any fields where the condition is true, and divide the sum of the remaining values by this new "total". If none of the fields has a value of "N/A"). I have set up the fields and form this way: Multiple choice text field to check for Condition, and associated fields for Value of Condition (If or Case formula, depending on # of conditions - Y/N, or Y/N/N/A) A "Subtotal" for groups of Values A Total of all Subtotals Missing: A % Total as described above