Excel formulas
2 Answer(s)
Vidya
COUNT
Formula: =COUNT(A1:A10)
The count formula counts the number of cells in a range that have numbers in them.
LEN
Formula: =LEN(A1)
The LEN formula counts the number of characters in a cell. Be careful though! This includes spaces.
TRIM
Formula: =TRIM(A1)
Gets rid of any space in a cell, except for single spaces between words.
NOW Returns the system date and time
TODAY Returns the system date, without the time
SUMIF Calculates a sum from a group of values, but just of values that are included because a condition is met
COUNTIF Counts the number of cells in a range that match a criteria
Jan 03 2014 07:58 PM
Formula: =COUNT(A1:A10)
The count formula counts the number of cells in a range that have numbers in them.
LEN
Formula: =LEN(A1)
The LEN formula counts the number of characters in a cell. Be careful though! This includes spaces.
TRIM
Formula: =TRIM(A1)
Gets rid of any space in a cell, except for single spaces between words.
NOW Returns the system date and time
TODAY Returns the system date, without the time
SUMIF Calculates a sum from a group of values, but just of values that are included because a condition is met
COUNTIF Counts the number of cells in a range that match a criteria
Joshua
You can find more formulas infact all the formulas in excel itself.
From the menu bar select "FORMULAS" and then choose your formula which is categorised in various headings.
Jan 09 2014 01:00 PM
From the menu bar select "FORMULAS" and then choose your formula which is categorised in various headings.