SOFTWARE EXCEL !
SOFTWARE EXCEL !
Microsoft Excel is an application to automatically process data that can be the basis of calculations , formulas , use functions , and tables of data processing , graphing and data management .
Microsoft Excel can also be used to complete various administrative purposes , from simple to complex . In Microsoft Excel workbooks we are working with the system , while there is a worksheet in the workbook or worksheet . In this worksheet we worked with using columns and rows that form a boxed into small cells where we enter the data .
To be able to use Microsoft Excel , ideally you should first master the basics of using Microsoft Windows and use the mouse . You also need to have a computer to these terms contained here and get to know the function of the buttons on the keyboard . Because later in practice , it is very important and helps you to save time, than if you do not know and do not know at all .
Note :
The fundamental difference between Excel with Lotus - 123 in use AND and OR is that in Excel , AND and OR is the formula of its own , so that each has two arguments , while the Lotus - 123 is not a formula , but as a link between the two conditions in one argument in the formula conditions ( as in the formula @ IF for example ) .
Based on the example above , we can conclude that :
* Teachers who have served for 10 years is the argument condition - 1 or the first condition that must be met by the data dievaluasinya .
* Master status = " PNS " is the argument condition - 2 or the second condition that must be met by the data dievaluasinya .
* Benefit from the government of 15% of Basic Salary is argument - X .
Now consider :
Argument - X will be given if the evaluated data meets the requirements of both conditions ( for formula AND ) or only one of the conditions enough ( for formula OR ) .
* Benefit from the government amounting to 5 % of Basic Salary is argument - Y .
Now consider :
Argument - Y will be given if the data were evaluated only the conditions are met ( for AND ) , or both do not meet the requirements as written in the argument condition
If the data to be evaluated and will be used as the first argument conditions contained in cell B4 , the second condition of the arguments contained in the cell C4 Salary while data is written to the cell D4 , then writing the formula is as follows
( NOTE : there should be no spaces in writing ! ) :
By using the AND
Excel :
= IF ( AND ( B4 > = 10 , C4 = " PNS " ) , * 15 % D4 , D4 * 5 % )
Lotus :
@ IF ( B4 > = 10 # AND # C4 = " PNS " , D4 * 15/100 , D4 * 5/100 )
By using the OR
Excel :
= IF ( OR ( B4 > = 10 , C4 = " PNS " ) , * 15 % D4 , D4 * 5 % )
Lotus :
@ IF ( B4 > = 10 # OR # C4 = " PNS " , D4 * 15/100 , D4 * 5/100 )
Writing this formula you can apply to the program Excel and Lotus with the operating system MS - DOS or PC - DOS , OS / 2 or Windows .
Microsoft Excel is an application to automatically process data that can be the basis of calculations , formulas , use functions , and tables of data processing , graphing and data management .
Microsoft Excel can also be used to complete various administrative purposes , from simple to complex . In Microsoft Excel workbooks we are working with the system , while there is a worksheet in the workbook or worksheet . In this worksheet we worked with using columns and rows that form a boxed into small cells where we enter the data .
To be able to use Microsoft Excel , ideally you should first master the basics of using Microsoft Windows and use the mouse . You also need to have a computer to these terms contained here and get to know the function of the buttons on the keyboard . Because later in practice , it is very important and helps you to save time, than if you do not know and do not know at all .
Note :
The fundamental difference between Excel with Lotus - 123 in use AND and OR is that in Excel , AND and OR is the formula of its own , so that each has two arguments , while the Lotus - 123 is not a formula , but as a link between the two conditions in one argument in the formula conditions ( as in the formula @ IF for example ) .
Based on the example above , we can conclude that :
* Teachers who have served for 10 years is the argument condition - 1 or the first condition that must be met by the data dievaluasinya .
* Master status = " PNS " is the argument condition - 2 or the second condition that must be met by the data dievaluasinya .
* Benefit from the government of 15% of Basic Salary is argument - X .
Now consider :
Argument - X will be given if the evaluated data meets the requirements of both conditions ( for formula AND ) or only one of the conditions enough ( for formula OR ) .
* Benefit from the government amounting to 5 % of Basic Salary is argument - Y .
Now consider :
Argument - Y will be given if the data were evaluated only the conditions are met ( for AND ) , or both do not meet the requirements as written in the argument condition
If the data to be evaluated and will be used as the first argument conditions contained in cell B4 , the second condition of the arguments contained in the cell C4 Salary while data is written to the cell D4 , then writing the formula is as follows
( NOTE : there should be no spaces in writing ! ) :
By using the AND
Excel :
= IF ( AND ( B4 > = 10 , C4 = " PNS " ) , * 15 % D4 , D4 * 5 % )
Lotus :
@ IF ( B4 > = 10 # AND # C4 = " PNS " , D4 * 15/100 , D4 * 5/100 )
By using the OR
Excel :
= IF ( OR ( B4 > = 10 , C4 = " PNS " ) , * 15 % D4 , D4 * 5 % )
Lotus :
@ IF ( B4 > = 10 # OR # C4 = " PNS " , D4 * 15/100 , D4 * 5/100 )
Writing this formula you can apply to the program Excel and Lotus with the operating system MS - DOS or PC - DOS , OS / 2 or Windows .
0 Response to " SOFTWARE EXCEL "
Posting Komentar