Kuyerekezera Operekera

Excel ndi Google Spreadsheet Oyerekeza asanu ndi limodzi

Ogwira ntchito, ambiri, ndi zizindikiro zomwe zimagwiritsidwa ntchito m'mafomu kuti afotokoze mtundu wa mawerengedwe omwe ayenera kutengedwa.

Wogwiritsira ntchito, monga momwe dzina limatchulira, amayerekezera pakati pa mfundo ziwiri muzondomekoyo ndi zotsatira za kufananitsa kwake zikhoza kukhala ZOONA kapena ZONSE.

Oyerekeza asanu ndi limodzi ogwira ntchito

Monga momwe tawonetsera pa chithunzi pamwambapa, pali opangira asanu ndi limodzi omwe amagwiritsidwa ntchito m'mapulogalamu a spreadsheet monga Excel ndi Google Spreadsheets.

Ogwiritsira ntchitowa amagwiritsidwa ntchito kuti ayese zinthu monga:

• kufanana kwa chiwerengero, monga 5 = 5,
• kusayenerera kwa chiwerengero,
  • monga 4 <> 5 (samafanana)
  • kapena 5> = 4 (wamkulu kapena wofanana).

Gwiritsani ntchito mawonekedwe a cell

Excel imasinthasintha kwambiri momwe njirazi zingagwiritsire ntchito. Mwachitsanzo, mutha kuzigwiritsa ntchito poyerekeza maselo awiri , kapena kuyerezerani zotsatira za chimodzi kapena zambiri zolembera . Mwachitsanzo:

• = A1 = A2
• = A1 = (A2 * 5)
• = (A1 * 10) <= (A2 / 5)

Monga momwe zitsanzozi zikusonyezera, mukhoza kuzilemba izi mosapita m'kati mwa Excel ndipo Excel iwerengere zotsatira za njirayi monga momwe zikanakhalira ndi njira iliyonse.

Ndi machitidwe awa, Excel nthawi zonse idzabwereranso kukhala OONA kapena OTHANDIZA monga zotsatira mu selo.

Ogwiritsira ntchito angagwiritsidwe ntchito mu fomu yomwe ikufanizira zikhalidwe mu maselo awiri mu tsamba la zolemba .

Kachiwiri, zotsatira za mtundu uwu wazomwe zidzangokhala zowona kapena ZONSE.

Mwachitsanzo, ngati selo A1 liri ndi chiwerengero cha 23 ndi selo A2 liri ndi nambala 32, fomu = A2> A1 ikhoza kubwezera zotsatira za TRUE.

Fomu = A1> A2, kumbali inayo, idzabwezera zotsatira za FALSE.

Gwiritsani ntchito Mafotokozedwe Otsatira

Ogwirizanitsa ntchito amagwiritsidwanso ntchito m'mawu ovomerezeka, monga ndondomeko ya ntchito ya IF ngati mwachindunji kuti mudziwe kusiyana kapena kusiyana pakati pa mfundo ziwiri kapena ntchito.

Mayeso oyenerera akhoza kufanana pakati pa mafotokozedwe awiri monga:

A3> B3

Kapena lingaliro loyenerera lingakhale kuyerekezera pakati pa mawonekedwe a selo ndi chiwerengero chokhazikika monga:

C4 <= 100

Pankhani ya ntchito ya IF, ngakhale kuti mayankho a zolemba zenizeni amangoyerekezera kuti ndi OONA kapena OYENERA, ntchito ya IF siyikuwonetsa zotsatira izi m'maselo apakompyuta.

M'malo mwake, ngati chiyeso choyesedwa chiri chowonadi, ntchitoyi ikuchita zomwe zili mu ndondomeko ya Value_if_yowona .

Ngati, ngati mkhalidwe woyesedwa uli WOLEMBEDWA, ntchito yomwe ili mu ndondomeko ya Value_if_false ikutsatiridwa m'malo mwake.

Mwachitsanzo:

= IF (A1> 100, "Zoposa zana", "Zaka zana kapena zosachepera")

Mayeso oyenerera mu ntchito iyi IF amagwiritsidwa ntchito kudziwa ngati mtengo uli mu selo A1 uli wamkulu kuposa 100.

Ngati vutoli ndi loona (chiwerengero cha A1 chili chachikulu kuposa 100), uthenga woyamba oposa oposa zana amasonyezedwa mu selo momwe machitidwewo amakhala.

Ngati vutoli liri FALSE (chiwerengero cha A1 chili chochepa kapena chofanana ndi 100), uthenga wachiwiri Mmodzi kapena ochepa amasonyezedwa mu selo yomwe ili ndi mayendedwe.

Gwiritsani ntchito Macros

Ogwirizanitsa ntchito amagwiritsidwanso ntchito m'mawu ovomerezeka mu Excel macros , makamaka mu malupu, kumene zotsatira za kulinganitsa zimaganizira ngati kuyenera kuchitidwa.