Join David Rivers for an in-depth discussion in this video Using operators, part of Numbers 3 Essential Training.
So far working with some formulas and functions…here in our KinetEco budget file,…we've used some operators that are…arithmetic in nature.…There are a number of other operators…to explore including some that are used…in comparison so we're going to continue…working with this file.…If you'd skip to this movie, open up KEcobudget0504.…We're on the profit/loss summary sheet.…Let's start with our difference column here…clicking the first cell in the Total Income row…which is cell D3.…
Displays the formula down below that we used…to achieve that value.…It's C3 minus B3, the minus sign being the operator…that is used in arithmetic.…Now there are other operators as well…that are arithmetic in nature.…For example, if instead we wanted to show…a percentage for that difference,…we could change this formula.…Let's start with the equal sign.…What we're going to do is take the actual…divided by, let's use the slash on the keyboard,…you'll notice the appropriate operator…is inserted for us for division,…and then we'll select B3.…
- Creating and laying out spreadsheets
- Importing data
- Working with tables
- Adding images to cells
- Performing calculations with formulas and functions
- Creating charts
- Formatting text and numbers
- Including audio, video, and shapes
- Designing templates
- Printing and sharing spreadsheets
Skill Level Beginner
1. Getting Started with Numbers
2. Working with Spreadsheets
3. Working with Tables
4. Working with Table Styles
5. Using Formulas and Functions
6. Working with Charts
7. Working with Text and Numbers
8. Working with Objects
9. Creating Your Own Templates
10. Sharing Your Spreadsheets
- Mark as unwatched
- Mark all as unwatched
Are you sure you want to mark all the videos in this course as unwatched?
This will not affect your course history, your reports, or your certificates of completion for this course.Cancel
Take notes with your new membership!
Type in the entry box, then click Enter to save your note.
1:30Press on any video thumbnail to jump immediately to the timecode shown.
Notes are saved with you account but can also be exported as plain text, MS Word, PDF, Google Doc, or Evernote.