Even Function Odd Function

Number Result Number Result

9 10 9 9
8 8 8 9
6 6 6 7
11 12 11 11
13 14 13 13
14 14 14 15
18 18 18 19
21 22 21 21
17 18 17 17

Sumif Function
Name Item name Qty Rate Amount
Neha ram 5 3200 16000
Nelam ram 5 3200 16000
Raju Kumar ram 5 3200 16000
Juber Khan Keyboard 5 5000 25000
Rahul Keyboard 5 5000 25000
Raj kumar Keyboard 5 5000 25000
Aman Kumar Mouse 6 3000 18000
neha ram 6 3000 18000
Rajesh Mouse 6 3000 18000

Product Formula
QTY Rate Total
5 200 1000
6 120 720
8 130 1040
9 150 1350
10 70 700
15 85 1275
11 90 990
13 25 325
14 40 560
 FACT Function Power Function ROMAN
Number Result Number Power Result Number
7 5040 12 2 144 1
6 720 10 3 1000 5
5 120 8 4 4096 69
9 362880 6 3 216 8
3 6 5 2 25 40
4 24 25 3 15625 50
8 40320 11 5 161051 10
11 39916800 7 6 117649 9
10 3628800 6 6 46656 12

Int Function Mod Function

Number Result Number Div
50.6 50 44 3
Result 56.2 56 85 2
ram 66000 40.1 40 78 4
20.5 20 65 5
35.2 35 45 6
45.2 45 44 6
10.2 10 99 3
 ROMAN Sqrt Function SUM Function
Result Number Sqrt Result Number Result
I 100 10 54
V 625 25 63
LXIX 729 27 52 473
VIII 169 13 92
XL 36 6 52
L 121 11 50
X 144 12 60
IX 49 7 30
XII 1225 35 20

Function Round Function ABS Function

Result Number Result Number Result
2 50.6 51 -100 100
1 56.2 56 625 625
2 40.1 40 -729 729
0 20.5 21 169 169
3 35.2 35 36 36
2 45.2 45 -0.256 0.256
0 10.2 10 144 144
-49 49
1225 1225
 TODAY NOW Date
Insert Today date Insert Date Time 15-Feb-16
24-Jul-25 7/24/2025 16:42 16-Mar-17
13-May-18

Date Day Date Month

15-Feb-16 15 15-Feb-16 2
16-Mar-17 16 16-Mar-17 3
13-May-18 13 13-May-18 5
Day month year TIME
15 2 2016 7 30 20
16 3 2017 7:30 AM
13 5 2018

Date Year Day Month Year Date

15-Feb-16 2016 15 2 2016 2/15/2016
16-Mar-17 2017 16 3 2017 3/16/2017
13-May-18 2018 13 5 2018 5/13/2018
Time Hour MinuteSecound
5:45 AM 5 45 20
6:36 AM 6 36 30
7:25 AM 7 25 40
8:24 AM 8 24 10
4:15 AM 4 15 50
 Lower Proper
Name Result Name Result
RAHUL rahul RAHUL Rahul
Rahul rahul Rahul Rahul
Ram MoHAn ram mohan Ram MoHAn Ram Mohan
RAJ KUMAR raj kumar RAJ KUMAR Raj Kumar
Rahul rahul Rahul Rahul
kamlesh kamlesh kamlesh Kamlesh

CONCATENATE EXACT
First Name Last Name Result Name
Rahul Kumar Rahul Kumar Rahul
Sudheer Verma Sudheer Verma Sudheer
Rahul Mishra Rahul Mishra Rahul
Arvind Raj Arvind Raj Arvind
Rahul Gupta Rahul Gupta Rahul
Suneel Raj Suneel Raj Suneel
 Upper Left
Name Result Name Result
RAHUL RAHUL Rahul Rah
Rahul RAHUL Rahul Rah
Ram MoHAn RAM MOHAN Ram Mohan Ram
RAJ KUMAR RAJ KUMAR Raj Kumar Raj
Rahul RAHUL Rahul Rah
kamlesh KAMLESH Kamlesh Kam

EXACT Trim Dollar

Result Name Result
TRUE RAHUL RAHUL Number
FALSE Rahul Rahul 1250
TRUE Ram MoHAn Ram MoHAn 500
FALSE RAJ KUMAR RAJ KUMAR 250
TRUE Rahul Rahul 650
FALSE 450
55
120
66
 Right Mid Len
Name Result Name Result Name Result
Rahul ul Rahul ahu Rahul 5
Rahul ul Rahul ahu Rahul 5
Ram Mohan an Ram Mohaam Ram Moha 9
Raj Kumar ar Raj Kumar aj Raj Kumar 9
Rahul ul Rahul ahu Rahul 5
Kamlesh sh Kamlesh aml Kamlesh 7

Dollar
Result
$1,250.00
$500.00
$250.00
$650.00
$450.00
$55.00
$120.00
$66.00
 Rept Formula
Number Result
5 55555
7 77777
manoj manojmanojmanojmanojmanoj
6 66666
upciss upcissupcissupcissupcissupciss
3 33333
 Average Average A Count
Number Result Number Result Number Result
50 A 121
169 169 169
55 A A
h 118 729 155.857 729 6
144 144 144
121 A 81
169 49 49
 CountA Count Blank `
Number Result Number Result Data
A 25
169 169 upciss prime
55 252
729 7 729 3 upciss prime
144 144 22
52 upciss prime
49 49 22
` ` ` `
Result Number Result Number Result 30
121 121 25
169 169 20
150 140 30
3 729 729 729 49 22
144 144 25
81 81 22
49 49 19
`

30
 Hyperlink Vlook
Adca Full Course ADCA Notes Full Download ID Number
CCC Full Course CCC Notes Full Download 998098
Tally Full Course TALLY Notes Full Download 998099
998100
998101
998102
998103

ID Number
998103
 Vlookup Function
Name Hindi English Math Art Total Name
Rahul Kumar 55 84 71 37 247 Hindi
Mohan Kumar 47 42 51 30 170 English
Rohan Kumar 65 36 82 30 213 Math
Vikash Kumar 46 45 50 85 226 Art
Raj Kumar 41 34 80 36 191 Total
Naresh Gupta 78 72 81 89 320

Result
Name Hindi English Math Art Total
Naresh Gupta 78 72 81 89 320
 Hlookup & Match Function
Rahul Kumar Mohan Kumar Rohan Kumar Vikash Kumar Raj Kumar
55 47 65 46 41
84 42 36 45 34
71 51 82 50 80
37 30 30 85 36
247 170 213 226 191

Result
Name Rohan Kumar
Total 213
Naresh Gupta
78
72
81
89
320
 And OR
Name Salary Result Name Class Result
Neha 2122 TRUE Neha High School TRUE
Nelam 2835 FALSE Nelam Enter TRUE
Raju Kumar 2152 TRUE Raju Kumar Eight FALSE
Juber Khan 2781 FALSE Juber Khan High School TRUE
Rahul 2119 TRUE Rahul Eight FALSE
Raj kumar 2409 TRUE Raj kumar Forth FALSE
Aman Kumar 2349 TRUE Aman Kumar High School TRUE
neha 2820 FALSE neha Enter TRUE
Rajesh 2008 TRUE Rajesh Forth FALSE
 Not IF
Name Class Result Name Course Marks
Neha High School FALSE Neha ADCA 52
Nelam Enter TRUE Nelam CCC 80
Raju Kumar Eight TRUE Raju Kuma ADFA 51
Juber Khan High School FALSE Juber KhanADCA 60
Rahul Eight TRUE Rahul CCC 73
Raj kumar Forth TRUE Raj kumar ADCA 65
Aman Kumar High School FALSE Aman KumCCC 59
neha Enter TRUE neha ADFA 52
Rajesh Forth TRUE Rajesh ADCA 30
Result
C
A
C
C
B
B
C
C
F
 month
Loan Amount 600000 1
Interset Rate 12% 2
Loan Period 2 3
4
PMT ( Monthly EMI) ₹28,244.08 5
IPMT (Intrest) ₹6,000.00 6
PPMT (Principal Amount) ₹22,244.08 7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
Monthly EMI Intrest Rate Principal Amount
₹28,244.08 ₹6,000.00 ₹22,244.08
₹28,244.08 ₹5,777.56 ₹22,466.52
₹28,244.08 ₹5,552.89 ₹22,691.19
₹28,244.08 ₹5,325.98 ₹22,918.10
₹28,244.08 ₹5,096.80 ₹23,147.28
₹28,244.08 ₹4,865.33 ₹23,378.76
₹28,244.08 ₹4,631.54 ₹23,612.54
₹28,244.08 ₹4,395.42 ₹23,848.67
₹28,244.08 ₹4,156.93 ₹24,087.15
₹28,244.08 ₹3,916.06 ₹24,328.03
₹28,244.08 ₹3,672.78 ₹24,571.31
₹28,244.08 ₹3,427.06 ₹24,817.02
₹28,244.08 ₹3,178.89 ₹25,065.19
₹28,244.08 ₹2,928.24 ₹25,315.84
₹28,244.08 ₹2,675.08 ₹25,569.00
₹28,244.08 ₹2,419.39 ₹25,824.69
₹28,244.08 ₹2,161.15 ₹26,082.94
₹28,244.08 ₹1,900.32 ₹26,343.77
₹28,244.08 ₹1,636.88 ₹26,607.20
₹28,244.08 ₹1,370.81 ₹26,873.28
₹28,244.08 ₹1,102.07 ₹27,142.01
₹28,244.08 ₹830.65 ₹27,413.43
₹28,244.08 ₹556.52 ₹27,687.56
₹28,244.08 ₹279.64 ₹27,964.44