Completed
) Formula 10: Goal: Determine If Employee Gets a Bonus: =C135 Greater Than =$F$135. Logical Formula.
Class Central Classrooms beta
YouTube videos curated by Class Central.
Classroom Contents
Excel Basics - Complete Formula Lesson of Formula Types & Formula Elements With Examples
Automatically move to the next video in the Classroom when playback concludes
- 1 ) Introduction
- 2 ) Different Types of Formulas
- 3 ) Formula Elements – what you can out into a formula.
- 4 ) Formula 01: Goal: Add calls made a service center last week.: =SUM(C23:C29) . Number Formula.
- 5 ) Formula 02: Goal: Calculate Monthly Insurance Expense.: =C37/12. Number Formula.
- 6 ) Formula 03: Goal: Calculate Deduction for Each Employee.: =ROUND(C46*$F$46,2) . Number Formula.
- 7 ) Formula 04: Goal: Calculate Cost of Goods Sold (COGS) in Accounting: =(C58-D58)*E58. Number Formula.
- 8 ) Formula 05: Goal: Join "Text " and an Item Number into One Cell.: ="Item # "&C70. Text Formula.
- 9 ) Formula 06: Goal: Join First & Last Names into One Cell.: =C82&", "&B82. Text Formula.
- 10 ) Formula 07: Goal: Extract State Abbreviation using the RIGHT Function: =RIGHT(B96,2) . Text Formula.
- 11 ) Formula 08: Goal: Extract Product Number using the LEFT Function: =LEFT(B108,6) . Text Formula.
- 12 ) Formula 09: Goal: Determine If Debits = Credits: =B127=C127. Logical Formula.
- 13 ) Formula 10: Goal: Determine If Employee Gets a Bonus: =C135 Greater Than =$F$135. Logical Formula.
- 14 ) Formula 11: Goal: Count how many of each product we sold: =COUNTIFS($B$148:$B$153,B156). Number Formula.
- 15 ) Formula 12: Goal: Formula to determine whether we need to reorder?: =$D$173 Greater Than B166-C166. Logical Formula.
- 16 ) Formula 13: Goal: Calculate Net Income: =C181-SUM(C182:C185) . Number Formula.
- 17 ) Summary - Conclusion
