9-21
ﻲﻃﺮﺸﻟﺍ ﻖﻴﺴﻨﺘﻟﺍ .4
ﻥﻮﻟ) ﻖﻴﺴﻨﺘﻟﺍ ﺪﻳﺪﺤﺘﺑ ﻡﻮﻘﺗ ﻲﺘﻟﺍ (A1<0 ﻞﺜﻣ) ﺔﻴﻃﺮﺸﻟﺍ ﺕﺍﺮﻴﺒﻌﺘﻟﺍ ﺮﻴﻴﻐﺘﻟ ﻲﻃﺮﺸﻟﺍ ﻖﻴﺴﻨﺘﻟﺍ ﺔﻔﻴﻇﻭ ﻡﺍﺪﺨﺘﺳﺍ ﻦﻜﳝ
.ﺔﻴﻠﺨﻠﻟ (ﺀﻼﻄﻟﺍ ﻂﳕ ﻭ ،ﻥﺎﻜﳌﺍ ﻥﻮﻟ ﻭ ،ﺺﻨﻟﺍ
ﻲﻃﺮﺸﻟﺍ ﻖﻴﺴﻨﺘﻟﺍ ﻦﻋ ﺔﻣﺎﻋ ﺓﺮﻈﻧ k
.ﺔﻴﻠﺧ ﻞﻜﻟ ﻁﻭﺮﺸﻟﺍ ﻦﻣ ﲔﻨﺛﺍ ﻰﺘﺣ ﺪﻳﺪﲢ ﻚﻨﻜﳝ
.ﻁﺮﺸﻟﺍ ﺔﺷﺎﺷ ﺮﻬﻈﺗ
6(g)5(CONDIT) ﻰﻠﻋ ﻂﻐﻀﻟﺎﺑ
ﻭﺃ 1 ﻁﺮﺸﻠﻟ 1(COND1) ﻂﻐﺿﺍ ﻢﺛ ﻦﻣﻭ "Condition" ﻂﺧ ﻰﻟﺍ ﻞﻴﻠﻈﺘﻟﺍ ﻙﺮﺣ ،ﺹﺎﳋﺍ ﻁﺮﺸﻟﺍ ﺭﺎﻴﺘﺧﻻ
.
2 ﻁﺮﺸﻠﻟ 2(COND2)
ﺔﻳﻮﻟﻭﻷﺍ ﺔﻴﻃﺮﺸﻟﺍ ﺕﺍﺮﻴﻐﺘﳌﺍ u
1 ﻁﺮﺸﻟﺍ ﻥﺎﻛ ﺍﺫﺍ .ﻞﻗﻷﺍ ﻢﻗﺮﻟﺍ ﺐﺣﺎﺻ ﻝﻭﻻﺍ ﻁﺮﺸﻟﺍ ﻦﻣ ﺎﻬﻘﻴﺒﻄﺗ ﻢﺘﻳ ،ﺔﻴﻠﳋ ﺓﺩﺪﺤﻣ ﻁﻭﺮﺷ ﺓﺪﻋ ﻚﻳﺪﻟ ﻥﻮﻜﺗ ﺎﻣﺪﻨﻋ
1 ﻁﺮﺸﻟﺎﺑ ﻖﻴﺴﻨﺘﻟﺍ ﺩﺪﺣ ﻭ A1=10 ﺪﻨﻋ ﻁﻭﺮﺸﻟﺍ ﻊﻴﻤﺟ ﺄﻓﺎﻜﺘﺗ 10≤A1≤20 2 ﻁﺮﺸﻟﺍ ،ﻝﺎﺜﳌﺍ ﻞﻴﺒﺳ ﻰﻠﻋ ،0≤A1≤10
.ﻖﺒﻄﳌﺍ
ﻊﻣ ﻭ (
9-13 ﺔﺤﻔﺻ) "ﺔﻴﻠﳋﺍ ﻖﻴﺴﻨﺗ ﺪﻳﺪﲢ" ﻥﺍﻮﻨﻋ ﺖﲢ ﺓﺭﻮﻛﺬﳌﺍ ﺕﺍﺀﺍﺮﺟﻹﺍ ﻡﺍﺪﺨﺘﺳﺎﺑ ﺓﺮﺷﺎﺒﻣ ﺔﻧﻮﻜﺘﻣ ﺔﻠﻴﳋﺍ ﺖﻧﺎﻛ ﺍﺫﺍ
.ﺓﺮﺷﺎﺒﳌﺍ ﺕﺍﺩﺍﺪﻋﻹﺍ ﻰﻠﻋ ﺔﻳﻮﻟﻭﻷﺍ ﻲﻃﺮﺸﻟﺍ ﻖﻴﺴﻨﺘﻟﺍ ﻖﻴﺒﻄﺗ ﺢﻨﻣ ﻢﺘﻳ ،ﻲﻃﺮﺸﻟﺍ ﻖﻴﺴﻨﺘﻟﺍ
ﻁﺮﺸﻟﺍ ﻉﺍﻮﻧﺃ u
.ﺮﻴﺒﻌﺘﻟﺍ ﻭ ﺔﻴﻠﳋﺍ ﺔﻤﻴﻗ :ﻁﺮﺸﻟﺍ ﻉﺍﻮﻧﺃ ﻦﻣ ﲔﻔﻠﺘﺨﻣ ﲔﻴﻋﻮﻧ ﺪﺟﻮﻳ
Value Of Cell :Type •
.ﺔﻴﻠﳋﺍ ﻰﻟﺍ ﺔﻤﻴﻘﻟﺍ ﻝﺎﺧﺩﺇ ﻊﺟﺮﲟ ﻡﻮﻘﺗ ﻲﺘﻟﺍ (
A1<0 ﻞﺜﻣ) ﺔﻐﻴﺼﻟﺍ ﻰﻠﻋ ﺀﺎﻨﺑ ﻁﺮﺸﻟﺍ ﻒﻳﺮﻌﺘﻟ ﺍﺬﻫ ﻁﺮﺸﻟﺍ ﻉﻮﻧ ﻡﺪﺨﺘﺳﺍ
.
1<A1 ﺪﻨﻋ ﻕﺭﺯﺃ ﻭ A1<0 ﺪﻨﻋ ﺮﻤﺣﺃ ﺎﻬ
ﹼ
ﺼﻧ ﻥﻮﻜﻳ ﺚﻴﺣ ،A1 ﺔﻴﻠﳋﺍ ﻦﻳﻮﻜﺗ ﻦﻜﳝ ﻝﺎﺜﳌﺍ ﻞﻴﺒﺳ ﻰﻠﻋ
Comments to this Manuals