Ich Lerne Excel
Ich Lerne Excel
Ich Lerne Excel
NOTE :
1. if command is easy to use (=if( condition, if true, if false))
ex : if u have a table with several numbers, and u want the number below 8 to be REMED
Score Result
8 LOLOS
7 REMED
9 LOLOS
7 REMED
7 REMED
10 LOLOS
5 REMED
7 REMED
8 LOLOS
2. you can use $ to make sure the equation always use that as reference, it can be row or cell
ex : u want to calculate payment each day wih a single row of price, the price is on the C so put the $ in front of
Books Sold Income
Title Price
03-Apr 04-Apr 03-Apr 04-Apr
Fairy Tail € 24.00 2 0 € 48.00 € -
Bleach € 91.00 3 1 € 273.00 € 91.00
Naruto € 54.00 1 1 € 54.00 € 54.00
Namaikizakari € 33.00 3 2 € 99.00 € 66.00
Hibi Choucho € 86.00 4 3 € 344.00 € 258.00
One Piece € 33.00 2 2 € 66.00 € 66.00
if the referencing is the row, put the in fron of the number (ex : C$3/D15)
Payroll
ross Total Overtime Overtime Bonus
29-Jan 27-Jan 28-Jan 29-Jan 27-Jan 28-Jan 29-Jan
Rp 468.00 0 1 5 Rp - Rp 15.60 Rp 78.00
Rp 342.00 0 0 2 Rp - Rp - Rp 30.40
Rp 272.00 0 2 1 Rp - Rp 27.20 Rp 13.60
Rp 231.00 1 0 0 Rp 15.40 Rp - Rp -
Rp 280.00 0 0 1 Rp - Rp - Rp 14.00
Rp 241.50 0 3 0 Rp - Rp 41.40 Rp -
Rp 272.00 0 4 1 Rp - Rp 54.40 Rp 13.60
Rp 306.00 1 0 2 Rp 13.60 Rp - Rp 27.20
Rp 308.00 0 0 1 Rp - Rp - Rp 15.40
Rp 248.50 0 0 0 Rp - Rp - Rp -
Rp 370.00 0 1 3 Rp - Rp 14.80 Rp 44.40
Rp 401.50 0 0 4 Rp - Rp - Rp 58.40
Rp 252.00 0 3 0 Rp - Rp 43.20 Rp -
Rp 216.00 1 2 0 Rp 14.40 Rp 28.80 Rp -
Rp 172.50 0 4 0 Rp - Rp 55.20 Rp -
Rp 241.50 0 1 0 Rp - Rp 13.80 Rp -
Rp 426.00 0 5 5 Rp - Rp 71.00 Rp 71.00
Rp 22.50 3 0 2 Rp 3.00 Rp - Rp 2.00
e row or cell
on the C so put the $ in front of the C
Nett Total
27-Jan 28-Jan 29-Jan
Rp 273.00 Rp 327.60 Rp 546.00
Rp 228.00 Rp 266.00 Rp 372.40
Rp 170.00 Rp 333.20 Rp 285.60
Rp 323.40 Rp 231.00 Rp 231.00
Rp 175.00 Rp 175.00 Rp 294.00
Rp 207.00 Rp 386.40 Rp 241.50
Rp 238.00 Rp 428.40 Rp 285.60
Rp 285.60 Rp 102.00 Rp 333.20
Rp 269.50 Rp 154.00 Rp 323.40
Rp 213.00 Rp 248.50 Rp 248.50
Rp 185.00 Rp 310.80 Rp 414.40
Rp 182.50 Rp 255.50 Rp 459.90
Rp 252.00 Rp 403.20 Rp 252.00
Rp 302.40 Rp 352.80 Rp 216.00
Rp 241.50 Rp 434.70 Rp 172.50
Rp 241.50 Rp 289.80 Rp 241.50
Rp 248.50 Rp 497.00 Rp 497.00
Rp 28.00 Rp 17.50 Rp 24.50
Chemistry
Physics
Physics
Thesis
Math
Math
Points Possible 10 8 9 1
Name
Ayaka 8 5 9 1 80% 63%
Boruto 9 6 4 1 90% 75%
Chongyun 7 8 5 1 70% 100%
Diluc 10 4 7 1 100% 50%
Erika 10 8 8 1 100% 100%
Francis 9 6 6 0 90% 75%
Gon 7 8 9 0 70% 100%
Hinata 8 5 5 1 80% 63%
Iida 9 4 8 1 90% 50%
Joestar 8 4 9 1 80% 50%
Kaneki 7 3 9 0 70% 38%
Lawliet 9 5 9 1 90% 63%
Masato 8 2 6 1 80% 25%
Nari 9 6 4 1 90% 75%
Otsuka 6 6 5 0 60% 75%
Paimon 10 4 8 0 100% 50%
Yuri 9 3 7 1 90% 38%
Ging 5 4 5 1 50% 50%
NOTE
1. to change axis of the chart, right click on he chart, then select data
2. or will show false eventhough one of the is true, vice versa
and will show the majority
3. to change axis of the chart, right click on he chart, then select data
4. combining if and or/and
Data Result
50 NO (using or)
25 YES (using and)
99
Math
Summer Class
12
Chemistry
10
Thesis 8
6
4
100% 100% no
2
44% 100% yes
0
56% 100% no a o n c a is n a a r i t o ri a n ri
ak ut yu ilu rik nc Go inat Iid esta nek wlie sat Na suk imo Yu Gi
78% 100% no Ay Bor ong D E Fra H Jo K La Ma
a Ot Pa
89% 100% no Ch
67% 0% yes
100% 0% yes Physics
56% 100% yes 9
8
89% 100% no 7
100% 100% no 6
100% 0% yes 5
4
100% 100% no
3
67% 100% yes 2
44% 100% yes 1
56% 0% yes 0
a o n c a is n a a r i t o ri a n ri
89% 0% yes y ak rut gyu Dilu Erik anc Go inat Iid esta nek wlie sat Na suk imo Yu Gi
A B ono Fr H Jo K La Ma
a Ot Pa
78% 100% yes Ch
56% 100% yes
Chemistry
10
8
6
4
2
0
a o n c a is n a a r i t o ri a n r i
yak rut gyu Dilu Erik anc Go inat Iid esta nek wlie sat Na suk imo Yu Gi
o
A B on Fr H Jo K La Ma
a Ot P a
Ch
th
r i t i i
ta nek lie sato Nar suka mon Yur Ging
a aw a t i
K L M O Pa
ics
r i t i i
ta nek lie sato Nar suka mon Yur Ging
a w a t i
K La M O Pa
istry
r i t i i
ta nek lie sato Nar suka mon Yur Ging
a aw a t i
K L M O Pa
Month Transaction Product Code Product Description Store Cost Sale Price Profit
Number