Momwe mungakopere fomula yeniyeni mu Excel

Mukakopera fomula, Excel imangosintha ma cell a cell kuti fomulayo ikopedwe mu selo iliyonse yatsopano.

Mu chitsanzo pansipa, selo A3 ili ndi chilinganizo chomwe chimawerengera zomwe zili m'maselo A1 и A2.

Lembani fomula iyi ku selo B3 (sankhani cell A3, dinani njira yachidule ya kiyibodi CTRL + C, sankhani selo B3, ndi kukanikiza Ctrl + V) ndipo fomulayo imangotanthauza zomwe zili mgululi B.

Ngati simukufuna izi, koma mukufuna kutengera chilinganizo chenicheni (popanda kusintha ma cell), tsatirani izi:

1. Ikani cholozera mu kapamwamba kapamwamba ndi kuunikila chilinganizo.
2. Dinani njira yachidule ya kiyibodi CTRL + CNdiye Lowani.
3. Onetsani selo B3 ndikudinanso fomula kapamwamba kachiwiri.
4. Press Ctrl + V, ndiye fungulo Lowani .

Zotsatira:

Tsopano ma cell onse (A3 и B3) ali ndi njira yomweyo.