what are different formulae used in exel? a no like 25 is not considered in exel as number why
Answers
Answer:what are different formulae used in exel?
SUM. The SUM function. The function will sum up cells that are supplied as multiple arguments. ...
AVERAGE. The AVERAGE function. ...
COUNT. The COUNT function. ...
COUNTA. Like the COUNT function, COUNTA. ...
IF. The IF function. ...
TRIM. The TRIM function. ...
MAX & MIN. The MAX.
2.Periodically, you may encounter numbers in Excel that you can't sum or use arithmetically. A common cause for this is numbers formatted as text. Often, reports exported from other programs, such as an accounting package, will be formatted as text or they might contain embedded spaces.
Explanation:
Explanation:
Seven Basic Excel Formulas For Your Workflow
SUM. The SUM function. The function will sum up cells that are supplied as multiple arguments. ...
AVERAGE. The AVERAGE function. ...
COUNT. The COUNT function. ...
COUNTA. Like the COUNT function, COUNTA. ...
IF. The IF function. ...
TRIM. The TRIM function. ...
MAX & MIN. The MAX.