what are the points to be taken care of while writing the format of a function in ms excel ????
Answers
Answer:
The OR function is a logical function to test multiple conditions at the same time. OR returns either TRUE or FALSE. For example, to test A1 for either "x" or "y", use =OR(A1="x",A1="y").SUM(number1, [number2], …) ...
=SUM(A2:A8) – A simple selection that sums the values of a column.
=SUM(A2:A8)/20 – Shows you can also turn your function into a formula. ...
=AVERAGE(number1, [number2], …) ...
=AVERAGE(B2:B11) – Shows a simple average, also similar to (SUM(B2:B11)/10)A function is a predefined formula that performs calculations using specific values in a particular order. All spreadsheet programs include common functions that can be used for quickly finding the sum, average, count, maximum value, and minimum value for a range of cells.The IF function is one of the most popular functions in Excel, and it allows you to make logical comparisons between a value and what you expect. So an IF statement can have two results. The first result is if your comparison is True, the second if your comparison is False.
Answer:
Points to be taken care while writing
1. Each function must begin with an equal to (=) sign.
2. Argument are written within the parenthesis separated by Lomas.