1.functions and Formulas
1.functions and Formulas
1.functions and Formulas
Functions (Sum, Count, Average, Max, Min, Sumif, Countif, Sumifs, Countifs)
Total Sales ₹ 730,880.00
Total Quantity 15,967
Number of Products 10
Average Quantity 1,597
Average Sales ₹ 73,088.00
Maximum Sales ₹ 230,850.00
Minimum Sales ₹ 6,200.00
Total Sales of Notebooks ₹ 461,640.00
Number of Products having sales
more than Rs. 1 lac 3
Total Sales of Products having unit
price more than Rs. 40 ₹ 469,180.00
Number of Products having sales
more than Rs. 1 lac and quantity
more than 2500 2
Count Number of Orders 10
ountif, Sumifs, Countifs)
AND OR NOT TRUTH TABLE
5 10 0 1 FALSE
20 10 1 0 TRUE T
T
F
IF Condition if(logical_condition, [value_if_true],[value_if_false]) F
Age 16 25
Solution Cannot Vote Can Vote T
T
Marks 30 85 F
Solution Fail Pass F
OR
T T
F T
T T
F F
Score Grade
<140 F
>=140 and <200 B
>=200 and <260 A
>=260 O
1 2 3 4 5 6 7 8 9 10
2 4 6 8 10 12 14 16 18 20
3 6 9 12 15 18 21 24 27 30
4 8 12 16 20 24 28 32 36 40
5 10 15 20 25 30 35 40 45 50
6 12 18 24 30 36 42 48 54 60
7 14 21 28 35 42 49 56 63 70
8 16 24 32 40 48 56 64 72 80
9 18 27 36 45 54 63 72 81 90
10 20 30 40 50 60 70 80 90 100
Working with Formula using $ (Relative, Absolute and Mixed Cell Reference)
First Name Last Name Full Name
GAURAV PATIL GAURAV PATIL Concatenate
SHASHANK IYER shashank iyer Concat + Lower
Sanika Sinha SANIKA SINHA Concat+Upper
ANAGHA SHARMA Anagha Sharma Concat+Proper
ADITI JOSHI aditi joshi Concat+lower
Price 1236534.8
Price to print Rs.1,236,534.80
Phone 8104365281
Phone to print +91 81 04 365 281
Code 9345
Code to print 009345
Text Function
Sweta 0 isblank
#DIV/0! 1 iserror
123 0 istext
Sweta 0 isnumber
#DIV/0! Error iferror
5
Text Functions
Upper, Lower, Proper, Concatenate, Left, Right, Mid
Date Functions
Day, Month, Year, Text, Datedif
Information Functions
IsBlank, IfError, IsText, IsNumber
7/29/2024
7/29/2024 19:15