User Manual

9-15
ﺓﺪﻤﻋﻷﺍ ﻝﺎﺧﺩﻹ •
.ﺎﻬﻟﺎﺧﺩﺍ ﺪﻳﺮﺗ ﻲﺘﻟﺍ ﺓﺪﻤﻋﻷﺍ ﺩﺪﻋ ﺲﻔﻧ ﺮﺘﺧﺍ ،ﻝﺎﺧﺩﻹﺍ ﺀﺍﺩﺍ ﻢﺘﻳ ﻥﺍ ﺪﻳﺮﺗ ﺚﻴﺣ ﺩﻮﻤﻌﻟﺍ ﲔﳝ ﻲﻓ ﺓﺮﺷﺎﺒﻣ ﺩﻮﻤﻌﻟﺍ ﻦﻣ ﺍﺀﺪﺑ
.ﺦﻟﺍ ،B2:D4، B10:D20 ﺭﺎﻴﺘﺧﺍ ﻚﻨﻜﳝ ،B ﺩﻮﻤﻌﻟﺍ ﺭﺎﺴﻳ ﻲﻓ ﺓﺪﻤﻋﺃ ﺔﺛﻼﺛ ﻝﺎﺧﺩﻹ :ﻻﺎﺜﻣ
.
4(INS) ﻂﻐﺿﺇ . 2
. J ،ﻰﻠﻋ ﻂﻐﺿﺇ ، ﺖﻗﻮﻟﺍ ﺍﺬﻫ ﻲﻓ ﻝﺎﺧﺩﻹﺍ ﺔﻴﻠﻤﻋ ﺀﺎﻐﻟﺇ ﻲﻓ ﻚﺘﺒﻏﺭ ﺕﺭﺮﻗ ﺍﺫﺍ .ﻝﺎﺧﺩﻺﻟ
ﹰ
ﺍﺩﺍﺪﻌﺘﺳﺍ ﺍﺬﻫ ﻞﺧﺪﻴﺳ •
.ﺩﻮﻤﻌﻟﺍ ﻝﺎﺧﺩﻹ
2(COL) ﻭﺍ ﺔﻘﺒﻄﳌﺍ ﻑﻮﻔﺼﻟﺍ ﺩﺪﻋ ﻝﺎﺧﺩﻹ 1(ROW) ﻰﻠﻋ ﻂﻐﺿﺇ . 3
ﺕﺎﻧﺎﻴﺑ ﻰﻠﻋ ﻱﻮﺘﲢ ﻲﺘﻟﺍ ﺓﺩﻮﺟﻮﳌﺍ ﺎﻳﻼﳋﺍ ﻚﻳﺮﲢ ﻲﻓ ﺐﺒﺴﺘﺗ ﻝﺎﺧﺩﻹﺍ ﺔﻴﻠﻤﻋ ﺖﻧﺎﻛ ﺍﺫﺍ
ERROR ﻕﺎﻄﻧ ﺙﺪﺤﻳ •
.A1:Z999 ﻦﻣ ﻕﺎﻄﻨﻟﺍ ﺝﺭﺎﺧ ﻲﻓ
ﺓﺩﺪﶈﺍ ﺎﻳﻼﳋﺍ ﻦﻣ ﺕﺎﻳﻮﺘﶈﺍ ﺢﺴﳌ u
. 5(CLR) ﻂﻐﺿﺇ ﻢﺛ ﻦﻣ ﻭ ﺢﺴﳌﺍ ﺪﻳﺮﺗ ﻲﺘﻟﺍ ﺔﻴﻠﳋﺍ ﻕﺎﻄﻧ ﻭﺍ ﺔﻴﻠﳋﺍ ﺮﺘﺧﺍ
ﺔﺻﺎﳋﺍ S •
SHT
ﻊﺿﻮﻟﺍ ﺮﻣﺍﻭﺃ ﻡﺍﺪﺨﺘﺳﺍ . 3
ﻱﺬﻟﺍ ،Celllf( ﻭ ،ﺎﻳﻼﳋﺍ ﻕﺎﻄﻧ ﺔﻋﻮﻤﺠﻣ ﺪﻴﻌﻳ ﻱﺬﻟﺍ ،CellSum( ﻮﺤﻧ ﺔﺻﺎﳋﺍ ﺮﻣﺍﻭﻷﺍ ﻦﻣ ﺩﺪﻋ S • SHT ﻊﺿﻮﻠﻟ
.ﻎﻴﺼﻟﺍ ﻞﺧﺍﺩ ﺎﻬﻣﺍﺪﺨﺘﺳﺍ ﻦﻜﳝ ﺔﺻﺎﳋﺍ ﺮﻣﺍﻭﻷﺍ ﻩﺬﻫ .ﺔﻋﺮﻔﺘﻣ ﻁﻭﺮﺷ ﺺﺼﺨﻳ
ﺹﺎﳋﺍ S • SHT ﻊﺿﻮﻟﺍ ﺮﻣﺃ ﺔﻤﺋﺎﻗ k
.ﻂﻘﻓ ﺔﻴﻠﳋﺍ ﻝﺎﺧﺩﺍ ﻝﻼﺧ ﺎﻫﺅﺍﺩﺃ ﻦﻜﳝ "ﻝﺎﺧﺩﻹﺍ ﺡﺎﺘﻔﻣ ﺔﻴﻠﻤﻋ" ﺕﺎﻴﻠﻤﻋ
. ﺮﻣﺃ ﻞﻛ ﺐﻴﻛﺮﺗ ﻲﻓ ([ ]) ﺱﺍﻮﻗﻷﺍ ﻲﻓ ﻦﻤﻀﺘﻣ ﺊﻴﺷ ﻞﻛ ﻑﺬﺣ ﻚﻨﻜﳝ.
ﺮﻣﻷﺍﻞﻴﺼﻔﺘﻟﺍ
CellIf(
(ﻁﺮﺷ ﻉﺮﻓ)
ﻥﻮﻜﺗ ﻉﺮﻔﻟﺍ ﻁﻭﺮﺷ ﺚﻴﺣ ﺕﺎﻨﻳﺎﺒﺘﻣ ﻭﺍ ﺓﺍﻭﺎﺴﻣ ﺮﻓﻮﺗ ﺎﻣﺪﻨﻋ
1 ﺮﻴﺒﻌﺘﻟﺍ ﺪﻴﻌﻳ
. ﺄﻄﺧ ﻥﻮﻜﺗ ﺎﻣﺪﻨﻋ 2 ﺮﻴﺒﻌﺘﻟﺍ ﻭ ،ﺔﺤﻴﺤﺻ
4(If) : ﻝﺎﺧﺩﻹﺍ ﺡﺎﺘﻔﻣ ﺔﻴﻠﻤﻋ
ﻭﺍ CellIf(ﺓﺍﻭﺎﺴﻣ, 1 ﺮﻴﺒﻌﺘﻟﺍ, 2 ﺮﻴﺒﻌﺘﻟﺍ[)] : ﺐﻴﻛﺮﺘﻟﺍ
CellIf(ﺕﺎﻨﻳﺎﺒﺘﻣ, 1 ﺮﻴﺒﻌﺘﻟﺍ, 2 ﺮﻴﺒﻌﺘﻟﺍ[(]
=CellIf(A1>B1, A1, B1) : ﻝﺎﺜﻣ
ﺪﻴﻌﻳ ،
ﹼ
ﻻﺇ ﻭ .
{B1 ﺔﻴﻠﳋﺍ ﺔﻤﻴﻗ} < {A1 ﺔﻴﻠﳋﺍ ﺔﻤﻴﻗ} ﺪﻨﻋ A1 ﻝ ﺔﻤﻴﻘﻟﺍ ﺪﻴﻌﻳ
. B1 ـﻟ ﺔﻤﻴﻘﻟﺍ
CellMin(
(
ﻰﻧﺩﻻﺍ ﺔﻴﻠﳋﺍ ﺔﻤﻴﻗ)
. ﺔﻴﻠﺨﻠﻟ ﺩﺪﺤﻣ ﻕﺎﻄﻧ ﻲﻓ ﻯﺮﻐﺼﻟﺍ ﺔﻤﻴﻘﻟﺍ ﺪﻴﻌﻳ
5(CEL) 1(Min) : ﻝﺎﺧﺩﻹﺍ ﺡﺎﺘﻔﻣ ﺔﻴﻠﻤﻋ
CellMin(ﺀﺪﺒﻟﺍ ﺔﻴﻠﺧ:ﺀﺎﻬﺘﻧﻻﺍ ﺔﻴﻠﺧ[)] : ﺐﻴﻛﺮﺘﻟﺍ
=CellMin(A3:C5) : ﻝﺎﺜﻣ
.
A3:C5 ﺔﻴﻠﳋﺍ ﻕﺎﻄﻧ ﻲﻓ ﺕﺎﻧﺎﻴﺒﻠﻟ ﻯﺮﻐﺼﻟﺍ ﺔﻤﻴﻘﻟﺍ ﺪﻴﻌﻳ
CellMax(
(ﺔﻴﻠﳋﺍ ﻰﺼﻗﻻﺍ ﺔﻤﻴﻗ)
. ﺔﻴﻠﺨﻠﻟ ﺩﺪﺤﻣ ﻕﺎﻄﻧ ﻲﻓ ﻯﺮﺒﻜﻟﺍ ﺔﻤﻴﻘﻟﺍ ﺪﻴﻌﻳ
5 (CEL) 2 (Max) : ﻝﺎﺧﺩﻹﺍ ﺡﺎﺘﻔﻣ ﺔﻴﻠﻤﻋ
CellMax(ﺀﺪﺒﻟﺍ ﺔﻴﻠﺧ:ﺀﺎﻬﺘﻧﻻﺍ ﺔﻴﻠﺧ[)] : ﺐﻴﻛﺮﺘﻟﺍ
=CellMax(A3:C5) : ﻝﺎﺜﻣ
. A3:C5 ﺔﻴﻠﳋﺍ ﻕﺎﻄﻧ ﻲﻓ ﺕﺎﻧﺎﻴﺒﻠﻟ ﻯﺮﺒﻜﻟﺍ ﺔﻤﻴﻘﻟﺍ ﺪﻴﻌﻳ