إصدار السوفتوير 3.10 دليل المستخدم

9-25
ﻝﺎﺧﺩﻹ ﺍﺬﻫ ﻡﺍﺪﺨﺘﺳﺍ ﻚﻨﻜﳝ ،ﻝﺎﺜﳌﺍ ﻞﻴﺒﺳ ﻰﻠﻋ .ﻲﻃﺮﺸﻟﺍ ﺮﻴﺒﻌﺘﻟﺍ ﻰﻟﺍ "ERROR" ﻞﺧﺪﺗ ... 2(ERROR) -
ﺎﻬﻴﻟﺇ ﻉﻮﺟﺮﻟﺍ ﻢﺘﻳ ﻲﺘﻟﺍ ﺔﻴﻠﳋﺍ ﻲﻓ ﺎﺿﻭﺮﻌﻣ "
ERROR" ﻦﻜﻳ ﻢﻟ ﻭﺃ ﻥﺎﻛ ﺍﺫﺍ ﺎﻣ ﻰﻠﻋ ﺭﺍﺮﻘﻟﺍ ﺪﻤﺘﻌﻳ .A1=ERROR
.(ﺎﻨﻫ ﻝﺎﺜﳌﺍ ﻲﻓ A1) ﻲﻃﺮﺸﻟﺍ ﺮﻴﺒﻌﺘﻠﻟ
ﺔﻴﻠﳋﺍ ﻦﻜﺗ ﻢﻟ ﻭﺃ ﺖﻧﺎﻛ ﺍﺫﺍ ﺎﻣ ﻰﻠﻋ ﺭﺍﺮﻘﻟﺍ ﺪﻤﺘﻌﻳ .ﻲﻃﺮﺸﻟﺍ ﺮﻴﺒﻌﺘﻟﺍ ﻰﻟﺍ "
BLANK" ﻞﺧﺪﻳ ... 3(BLANK) -
.ﺔﻴﻟﺎﺧ ﻲﻃﺮﺸﻟﺍ ﺮﻴﺒﻌﺘﻟﺍ ﻲﻓ ﺎﻬﻴﻟﺇ ﻉﻮﺟﺮﻟﺍ ﻢﺘﻳ ﻲﺘﻟﺍ
.ﻲﻃﺮﺸﻟﺍ ﺮﻴﺒﻌﺘﻟﺍ ﻰﻟﺍ "
And" ﻲﻘﻄﻨﳌﺍ ﻞﻐﺸﳌﺍ ﻞﺧﺪﻳ ... 4(And) -
.ﻲﻃﺮﺸﻟﺍ ﺮﻴﺒﻌﺘﻟﺍ ﻰﻟﺍ "
Or" ﻲﻘﻄﻨﳌﺍ ﻞﻐﺸﳌﺍ ﻞﺧﺪﻳ ... 5(Or) -
ﺔﻈﺣﻼﻣ
.ﻲﻃﺮﺸﻟﺍ ﺮﻴﺒﻌﺘﻠﻟ ﺕﺎﻧﺎﻴﺒﻟﺍ ﻦﻣ ﺖﻳﺎﺑ 255 ﻰﺘﺣ ﻝﺎﺧﺩﺇ ﻚﻨﻜﳝ
ﻲﻓ ﻭﺍ ﻩﺎﻧﺩﺃ ﺓﺮﻫﺎﻈﻟﺍ ﺐﻴﻛﺍﺮﺘﻟﺍ ﻲﻓ ﻲﻃﺮﺸﻟﺍ ﺮﻴﺒﻌﺘﻟﺍ ﻲﻓ ﻂﻘﻓ ﺺﻨﻟﺍ ،
BLANK ،ERROR ﺕﺍﺮﻴﻐﺘﻣ ﻡﺍﺪﺨﺘﺳﺍ ﻦﻜﳝ
.(
A1 ﻞﺜﻣ) ﺓﺪﺣﺍﻮﻟﺍ ﺔﻴﻠﳋﺍ ﻊﺟﺮﳌ ﻡﻮﻘﻳ <Cell> (.ﺎﻫﺮﻴﻏﻭ ،ERROR=<Cell>) ﻚﻟﺫ ﺲﻜﻋ
<
Cell>=ERROR, <Cell>=BLANK, <Cell>ERROR, <Cell>BLANK, <Cell>=<ﺔﻴﺼﻧ ﺔﻠﺴﻠﺳ>,
<
Cell><ﺔﻴﺼﻧ ﺔﻠﺴﻠﺳ>
ﻲﻃﺮﺸﻟﺍ ﻖﻴﺴﻨﺘﻟﺍ ﺕﺍﺩﺍﺪﻋﺇ ﻑﺬﺣ u
.ﻲﻃﺮﺸﻟﺍ ﻖﻴﺴﻨﺘﻟﺍ ﻑﺬﺣ ﺪﻳﺮﺗ ﺚﻴﺣ ﺎﻳﻼﳋﺍ ﻕﺎﻄﻧ ﻭﺃ ﺔﻴﻠﳋﺍ ﺮﺘﺧﺍ .1
ﻱﺍ ﻚﻟﺬﻛﻭ ﻲﻃﺮﺸﻟﺍ ﻖﻴﺴﻨﺘﻟﺍ ﻦﻣ ﻞﻛ ،ﺔﻳﺪﻴﻛﺄﺗ ﺔﻟﺎﺳﺭ ﻱﺃ ﺽﺮﻋ ﻥﻭﺪﺑ ،ﺔﻋﺮﺴﺑ ﺢﺴﻤﻴﺳ ﺔﻴﻟﺎﺘﻟﺍ 2 ﺓﻮﻄﳋﺍ ﺬﻴﻔﻨﺘﺑ
.ﺓﺭﺎﺘﺍ (ﺎﻳﻼﳋﺍ) ﺔﻴﻠﺨﻠﻟ ﻥﻮﻜﺘﳌﺍ ﺀﻼﻄﻟﺍ ﻂﳕ ،ﻥﺎﻜﳌﺍ ﻥﻮﻟﻭ ،ﻑﻭﺮﳊﺍ ﻥﻮﻟ ﺕﺍﺩﺍﺪﻋﺇ ﻦﻣ
.
5(CLEAR)2(FORMAT) ﻂﻐﺿﺍ .2
ﻲﻃﺮﺸﻟﺍ ﻖﻴﺴﻨﺘﻟﺍ ﺩﺍﺪﻋﻹ ﻝﺎﺜﻣ k
ﻩﺬﻫ ﺽﺮﺘﻔﺗ .ﻩﺎﻧﺩﺃ ﺔﻨﻴﺒﳌﺍ ﻲﻃﺮﺸﻟﺍ ﻖﻴﺴﻨﺘﻟﺍ ﻊﻣ B3:C4 ﺎﻳﻼﳋﺍ ﻕﺎﻄﻧ ﻦﻳﻮﻜﺗ ﺔﻴﻔﻴﻛ ﺽﺮﻌﺑ ﻡﻮﻘﻧ ﻦﺤﻧ ﻝﺎﺜﳌﺍ ﺍﺬﻫ ﻲﻓ
.ﻞﻌﻔﻟﺎﺑ ﻢﻴﻗ ﻰﻠﻋ ﻱﻮﺘﲢ ﺎﻳﻼﳋﺍ ﻩﺬﻫ ﻥﺃ ﺕﺍﺀﺍﺮﺟﻹﺍ
ﻁﺮﺷ
ﻲﻓ ﺔﻤﻴﻘﻟﺍ ﻝﺎﺧﺩﺇ ﺊﻓﺎﻜﻳ ﺎﻣﺪﻨﻋ
:ﻁﺮﺸﻟﺍ ﺍﺬﻫ (
C=)ﺔﻴﻠﳋﺍ
:ﻖﻴﺴﻨﺘﻟﺍ ﺍﺬﻫ ﻖﻴﺒﻄﺗ ﻢﺘﻳ
ﻑﺮﳊﺍ ﻥﻮﻟﻥﺎﻜﳌﺍ ﻥﻮﻟﺀﻼﻄﻟﺍ ﻂﳕ
1C<0
ﻲﻌﻴﺒﻃﺮﻔﺻﺃﺮﻤﺣﺃ
2
0C100
ﻒﺧﺃﻲﻧﺍﻮﺟﺭﺃﻕﺭﺯﺃ