O itula faigaluega calculator i Excel

O lenei faʻataʻitaʻiga o le a aʻoaʻoina oe pe faʻapefea ona fai se calculator faʻatulagaina faigofie i Excel. O sela o lo'o iai fua fa'atatau e lanu samasama mama.

  1. Ina ia otometi le fuafuaina o le isi 4 aso pe a uma le aso amata, faʻaaoga fua faʻatatau o loʻo i lalo:
    • Mo sela B6:

      =TEXT(C6,"dddd")

      =ТЕКСТ(C6;"дддд")

    • Mo sela C6:

      =C5+1

  2. Filifili sela o iai le taimi.
  3. Kiliki-matau i luga oi latou, i le lisi autu filifili Faʻatulaga sela (Cell Format) ma seti le taimi sa'o. Mo sela R-12, R-13 и R-14 fa'aoga le fa'asologa o lo'o li'o i le ata o lo'o i lalo.
  4. Mo le fa'atatauina otometi i aso ta'itasi o itula faigaluega, fa'apea le aofa'i o itula ma ovataimi, fa'aaoga fua fa'atatau i lalo:
    • Mo le lautele K5: K9:

      =(F5-E5)+(I5-H5)

    • Mo sela R-12:

      =SUM(K5:K9)

      =СУММ(K5:K9)

    • Mo sela R-14:

      =IF(K12>K13,K12-K13,0)

      =ЕСЛИ(K12>K13;K12-K13;0)

Tuua se tali