Trunc: It truncates a number to an integer by removing the decimal or fractional, Part of the number. Syntax:- =mod(Dividend, Divisor) : The number to be divided. Mod: This function returns the reminder of a division. Syntax:- = product(base, exponent) : The base a of the power a^b Power: It returns the result of a number raised to a given Power. Syntax:- =product (Number1, Number2, …) : Number1, Number2, …are arguments to be multiplied and a result returned. Product: This multiplies of given numbers. Sum range (cell range from where similar value would be sum).range (cell range from which criteria would search).Syntax:- =sumif( range, criteria, sum-range) The range to be evaluated by the given criteria) This function require three field as given below: Sumif: It is used to sum the value according to the condition. Syntax- = rounddown(number, count) : The number to be rounded down. Rounddown: It rounds a number down, toward 0. Syntax- = roundup(number, count) : The number to be rounded up. Roundup: It rounds a number up, away from 0. Syntax- = round(number, count) : The number to be rounded. Round: It is used for round the number to a specified number for digits. Syntax- = sum(Number1, Number2, …) : Number1, Number2, …are arguments whose total are to be calculated. Sum (Range of Cells): It is used to add the cell values or range of cells.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |