Formulas allow spreadsheets to do complex and useful calculations. There are some conventions that Excel requires for formulas to give correct answers.