XL Sheet Formulas

-

XL sheet formula's:

1. SUM :-
Formula: =SUM(5, 5) or =SUM(A1, B1) or =SUM(A1:B5)

2. COUNT :- The count formula counts the number of cells in a range that have numbers in them.
Formula: =COUNT(A1:A10)

3. COUNTA :- Counts the number of non-empty cells in a range. It will count cells that have numbers and/or any other characters in them.
Formula: =COUNTA(A1:A10)

4. LEN :- The LEN formula counts the number of characters in a cell. Be careful though! This includes spaces.
Formula: =LEN(A1)

5. TRIM :- Gets rid of any space in a cell, except for single spaces between words.
Formula: =TRIM(A1)

6. RIGHT, LEFT, MID
Formulas: = RIGHT(text, number of characters), =LEFT(text, number of characters), =MID(text, start number, number of characters).
RIGHT(A1,2)

7. CONCATENATE :- A fancy word for combining data in 2 (or more) different cells into one cell.
Formula: =CONCATENATE(A1," ", B2)

Comments

Post a Comment

Popular posts from this blog

Spring Boot + Maven + RestFul + JPA + Sqlite

-
1. pom.xml  :- <?xml version="1.0" encoding="UTF-8"?> <project xmlns="http://maven.apache.org/POM/4.0.0" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:schemaLocation="http://maven.apache.org/POM/4.0.0 http://maven.apache.org/xsd/maven-4.0.0.xsd"> <modelVersion>4.0.0</modelVersion> <groupId>com.wfd</groupId> <artifactId>springDemo</artifactId> <version>0.0.1-SNAPSHOT</version> <packaging>jar</packaging> <name>springDemo</name> <description>Demo project for Spring Boot</description> <parent> <groupId>org.springframework.boot</groupId> <artifactId>spring-boot-starter-parent</artifactId> <version>2.0.4.RELEASE</version> <relativePath/> <!-- lookup parent from repository --> </parent> <properties> <project.build.sourceEncod
Read more

View & Materialized View

-
Comparison Chart BASIS FOR COMPARISON VIEW MATERIALIZED VIEW Basic A View is never stored it is only displayed. A Materialized View is stored on the disk. Define View is the virtual table formed from one or more base tables or views. Materialized view is a physical copy of the base table. Update View is updated each time the virtual table (View) is used. Materialized View has to be updated manually or using triggers. Speed Slow processing. Fast processing. Memory usage View do not require memory space. Materialized View utilizes memory space. Syntax Create View V As Create Materialized View V Build [clause] Refresh [clause] On [Trigger] As
Read more

JDBC with Sqlite

-
Image
                                              JDBC with Sqlite Step1:-  download sqlite JDBC jar with bellow URL. JDBC jar Step2:- create java application and import Jar. select application -> Right click -> Build Path -> Configure Build Path -> Libraries -> click "add external jars"-> select "slite-jdbc-3.23.1.jar" 1. 2. Step3 : write Java-Database connectivity logic import java.sql.Connection; import java.sql.DriverManager; import java.sql.ResultSet; import java.sql.SQLException; import java.sql.Statement; public class SqliteJdbc { public static void main(String[] args) throws ClassNotFoundException, SQLException { // load the sqlite-JDBC driver using the current class loader     Class.forName("org.sqlite.JDBC");     Connection connection = null;     String url="jdbc:sqlite:G:/SW/Development/database/sqlite-tools-win32-x86-3240000/sqlite-tools-win32-x86-3240000/sa
Read more