Formula and Functions in Excel

• Sum if column B is greater or equal to column C                                   =sumif(b:b,”>=”&c:c)
• What is the product of A4 and B4                                                              =AA4*B4
• Find the percentage of U17 multiply by G34 if cell I7 =88                   =if(17=88,(U17*G34)100,0)
• What is the sum of U7 and I8?                                                                   =sum(U7,I8)
• If cell U8=59 but is above 70, pass or fail?                                              =if(U8>70,”fail”,”pass”)

The formula is any mathematical operation performed in a Microsoft Excel application using the available mathematical operators such as the minus, addition, multiplications and many others.

However, functions can be defined as the predefined formulas in a workbook, spreadsheet or an MS Excel program. examples are:

• SUM
• SUMIF
• PRODUCT
• AVERAGE
• MIN
• MAX
• AVERAGEIF
• COUNT
• COUNTA
• RANK
• etc

Advantages of Functions

• It saves time
• Its the easiest command or syntax issued
• Very competitive when it comes to formulas
• It helps most users to have it as a compatible command in Ms Excel
• It is also considered the quickest and fastest command in Ms Application

About Author

SURF

See author's posts