Page 118 - الحاسب الآلي ثانية إرشاد 2

Excel ‫اﻟﺪوال ﻓﻰ ﺑﺮﻧﺎﻣﺞ‬ ‫اﻟﻔﺼﻞ اﻟﺴﺎﺑﻊ‬

=YEARFRAC("11/12/2018","1/1/1980")
38.94444444

DAYS360 -١٣

=DAYS360("11/12/2000","11/12/2018") - -١٤
6480

NETWORKDAYS
=NETWORKDAYS("01/04/٢٠١٨","01/05/٢٠١٨")
٢٢

‫دوال اﻟﺮﻳﺎﺿﻴﺎت واﻟﻤﺜﻠﺜﺎت‬

SQRT -١

= SQRT(100)
10

Int -٢

= INT(34.9)
34

ROUND ‫ ﻟﺘﻘﺮﻳﺐ‬-٣

=ROUND(23.35,1)
23.4
=ROUND(50.5,0)
51
=ROUND(50.5239,3)
50.524

ABS -٤

١١٨