Watch this video to learn how to create more complex formulas using multiple operators, cell references, and functions.
Other videos in this course
This video is part of a training course called Basic Math in Excel. You can download the entire course or watch the videos online:
- Video: Basic math in Excel 2013. Let Excel be your calculator. This video shows you how to add, subtract, multiply, and divide in your workbook.
- Video: Using functions in Excel 2013. A function is a predefined formula that helps save you time. For example, use the SUM function to add lots of numbers or cells, and the PRODUCT function to multiply them.
- Video: Operator order in Excel 2013. How do you know what part of your formula Excel acts on first, second, third, and so on? This video explains it.
- Video: More complex formulas in Excel 2013. (You are here!) Watch this video to learn how to create more complex formulas using multiple operators, cell references, and functions.
Need a reminder of what you learned? See the course summary.
Ready for another tutorial? See the complete list of Excel 2013 training courses.