Excel formulas



0
Let me know the few more excel formulas?

2 Answer(s)


1

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

0

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.

Your Answer

Click on this code-snippet-icon icon to add code snippet.

Upload Files (Maximum image file size - 1.5 MB, other file size - 10 MB, total size - not more than 50 MB)

Email
Password