COUNTIF

A B C D E F
1 Mon Tue Wed Thu Presents Absents
2 P P A A 3 2
3 P P P P 4 1
4 P P P P 3 2
5 A A A P 3 2
6 A P P A 3 3
(Formulla):- =countif(B1:E1,”P”) = Present
=countif(B1:E1,”A”) = Absent

PRODUCT
A B C D E
1 [Link] Item Quality Rate Amount
2 1 Mouse 10 250 =PRODUCT(C1,D1)
3 2 Keyboard 12 420 =PRODUCT(C2,D2)
4 3 Monitor 3 3000 =PRODUCT(C3,D3)
5 4 Pen Drive 15 320 =PRODUCT(C4,D4)
6 5 Ram 4 800 =PRODUCT(C5,D5)
(FORMULLA):- =PRODUCT(C1,D1)

SUM
A B C D E
1 Sr. No Quanity Rate Amount Total
2 1 Mouse 250 2500 =sum(D2:D6)
3 2 Keyboard 420 5040
4 3 Monitor 3000 9000
5 4 Pen Drive 320 4800
6 5 Ram 800 3200
(FORMULLA):- =SUM(D2:D6)
SUMIF
A B C D E
1 [Link] Item Quantity Rate Amount
2 1 T-shirt 10 250 2500
3 2 T-shirt 12 420 5040
4 3 Jeans 3 900 2700
5 4 T-shirt 15 320 4800
6 5 Jeans 4 800 3200
(FORMULLA):- =SUM(B2:B6,”T-shirt”,E2:E6)
MAX
A B C D
1 [Link] Name Post Salery
2 EM1001 DEEPAK MANAGEER 50000
3 EM1002 MUKESH WORKER 27000
4 EM1003 RAKESH WORKER 26000
5 EM1004 SUBHASH CLERK 25000
6 EM1005 SURESH WORKER 27500
FORMULLA:- =MAX(D2:D6)

TODAY
A B C D E
1 Em. Id Name Post Salery Joining Date
2 EM1001 DEEPAK MANAGER 25000 =TODAY()
3 EM1002 SHYAM WORKER 18000
4 EM1003 RAHUL SHOPKEEPAR 28000
5 EM1004 SANJEEV ADVOCATE 29000
6 EM1005 VIKASH CLERK 32000
FORMULLA:- =TODAY()

NOW
A B C D E
1 Em. Id Name Post Salery Joining Date & TIME
2 EM1001 DEEPAK MANAGER 25000 =NOW()
3 EM1002 SHYAM WORKER 18000
4 EM1003 RAHUL SHOPKEEPAR 28000
5 EM1004 SANJEEV ADVOCATE 29000
6 EM1005 VIKASH CLERK 32000
FORMULLA:- =NOW()

UPPER
A B C
1 [Link] Name Upper
2 EM1001 Deepak =UPPER(B2)
3 EM1002 Subhash
4 EM103 Rohit
5 EM1004 Mukesh
6 EM1005 Suresh
FORMULLA:- =UPPER(B2)
LOWER
A B C
1 [Link] Name Upper
2 EM1001 DEEPAK =LOWER(B2)
3 EM1002 SUBHASH
4 EM103 ROHIT
5 EM1004 MUKESH
6 EM1005 SURESH
FORMULLA:- =LOWER(B2)

PROPER
A B
1 NAME =PROPER(A2)
2 HrISH
3 ViVeK
4 puniT
5 RAGHAV
6 PoojA
7 DLPee
FORMULLA:- =PROPER(A2)

ROMAN
A B
1 NUMBER ROMAN
2 1 =ROMAN(A2)
3 2
4 3
5 4
6 5
7 6
FORMULLA: =ROMAN(A2)

AVERAGE
A B C
1 NAME SCORE AVERAGE
2 HARISH 500 =AVERAGE(B2:B5)
3 MOHAN 600
4 SOHAN 560
5 MUKESH 450
FORMULLA:- =AVERAGE(B2:B5)

TRIM A B
1 PADHI PE DHIYAN DO =TRIM(A1)
FORMULLA:- =TRIM(A1)