1.3 Rumus Merk Motor

Motor Brand and Selling Price Formula

Introduction to the Formula

• The video begins with an introduction to a formula sheet that includes motorcycle brands and selling prices. The speaker emphasizes typing in specific columns for manual input, focusing on key elements such as marketing name, motorcycle type, payment method, and summary.

Using Formulas to Identify Motorcycle Brands

• The speaker explains how to determine the motorcycle brand based on its type using a formula. They reference a resume indicating that "Honda PCX" corresponds to 1, "Honda Nmax" to 2, and "Honda YZF" to 3.

Implementing Conditional Logic in Formulas

• A detailed explanation of using the IF function is provided. The speaker demonstrates how to set up conditions: if the type equals 1 (i.e., Honda PCX), it returns that value; otherwise, it checks for other types.

Completing the Formula Structure

• The process continues with additional conditions for types 2 and 3. If neither condition is met (not type 1 or type 2), it defaults to "Honda YZF." This illustrates how nested IF statements can be used effectively.

Finalizing the Formula Entry

• The speaker concludes by emphasizing proper syntax in formulas—ensuring parentheses are closed correctly—and reminds viewers about pressing enter after completing their entry. This step is crucial for executing the formula successfully.