For our example, we'll show you how to set up a pretty simple (but pretty common) formula -- one designed to calculate financial status.
First, create a new question to hold the calculation. We'll call it "Total Available Funds, 2014-2015," because that's what we ultimately want this calculation to tell us.
On the new Calculation page, the Total Available Funds question has automatically been added.
Next, let's create the calculation by adding the income variables to our calculation. In this case, we're adding income from work, family contributions, and grants received. We'll also throw in an item to be subtracted-- interest paid.
Then we write our formula. This one is pretty straightforward:
Income from work (A) + family contributions (B) + grants received (C) - interest paid (D) is equal to "Total Available Funds, 2014-2015."
Great! Everything looks good. Now let's test it out. We plug some values into the test column...
Hit "Test and confirm," and voila! The test result that we get here is exactly what we would have gotten if we'd done all that work manually! No more time sinks or messy Excel spreadsheets!