Understand the Excel Formulas Writing Procedure

There are some basic things that you should pay attention to in the Formula Writing Procedure Excel and functions Microsoft Excel, because it will be very decisive results yang didapat dari penulisan rumus Microsoft Excel. This is because writing formulas requires considerable accuracy. There are some basic things that you should pay attention to in the Formula Writing Procedure Microsoft Excel There are some basic things that you should pay attention to in the Formula Writing Procedure (=), another example is the writing of double quotes / quotes (“) which is used to wrap text-type data, when this mark is less than one (1) only then it is possible that the calculation results of the formula will not appear.

There are two methods of writing formulas and functions in Microsoft Excel worksheets :
1. Type Manually Formulas and Functions
The point is that you have to type all the formulas one by one in a coherent and precise manner. For example, when you type the IF formula, then you have to type = IF in the cell where the formula and function are placed.
Example :
Type letters 4000, 6000, 6000, and 4000 each on cell A2, A3, A4, and A5 in your active sheet, then pay attention to the provisions :
* If price 4000, then filled with Tomato Juice,
* If the price 6000, then filled with Apple Juice,
To solve the above question, put the calculation result in cell B2, then in cell B2 type the formula =IF(A2 = 4000;”TjusTomat”;”Jus Apel”), then press Enter. Pay attention, In cell B2, the Tomato Juice results will appear, which is the result of the formula that you entered.

When you start typing formulas in Microsoft Excel, it will display a series of functions that have the prefix as you typed. You can use one of the formulas shown as in the image below :
picture 1

Kelebihan penulisan rumus dengan method manual :
this job takes a fairly short time because you do not need to activate certain dialog boxes.

lack of writing formulas manually :
you must be right – correctly memorize the type and arrangement of functions to be used in the formula, for example, if you are going to use the IF function in a formula then you must memorize the arrangement of the writing procedure.

2. Writing Formulas and Functions with the Wizard
Write formulas with steps Wizard means you just use the command button Insert Function (Fx).

Langkah menulis rumus dengan wizard untuk soal seperti pada subbab sebelumnya adalah :
a. Active on cell C2. On the tab FORMULAS group Function Library, select the Insert Function button until the Insert Function dialog box appears to select the type of function to be used.
b. Select the function category in the section Or select a category and select the function you want in the section Select a function, for example is IF function, then click OK until the dialog box appears Function Arguments.
c. In section Logical_test fill in the conditions that must be met, that is “A2=4000”.
d. In section Value_if_true fill in the value if the conditions are met or true, yaitu “Jus Tomat”. Sedangkan pada bagian Value_if_false isi dengan nilai jika syaratnya tidak terpenuhi atau salah yaitu “Jus Apel”.
e.click OK and attention to cell C2 will display the calculation result of the formula which displays the value of Tomato Juice.

Lack of writing formulas using the Wizard :
This job takes a while because you have to follow the steps provided one by one.

The advantages of writing formulas using the Wizard : 
This step is more thorough and very helpful for beginners who have not mastered and have not memorized the functions of Microsoft Excel, where each step taken will be accompanied by a description.

Another plus is that you can see the results and functions that you created directly at the bottom of the dialog box Fuchtion Arguments.

Thus the article about understand the procedure for writing formulas in Microsoft Excel , semoga apa yang sispendik.net bagikan bermanfaat buat kita semua. thank you

Similar Posts:

• Excel Formula Finds Due Date – Blog / items Microsoft Excel Rumus excels
• Excel Formula Calculates Percentage of Test Questions – Blog / items Microsoft Excel Rumus excels
• Understanding Types – Type of Error Code in Microsoft Excel – Blog / items Microsoft Excel Rumus excels
• Excel Formulas Create Pass Captions & Not pass – Blog / items Microsoft Excel Rumus excels
• How to Input Time with Various Formats – Microsoft Excel
• Quick Tricks to Run Excel on Windows – Microsoft Excel
• How to Display Data With Accounting Format – Microsoft Excel
• How to Make Subtotals in Excel – Microsoft Excel
• Secret Ways to Know Namespaces in PHP – Blog / items Studying Tutorial & Way
• Simple Way to Create Signature in Microsoft Word – Blog / items Tutorial & Way