Ungayibeka njani umqondiso ongalinganiyo kwi-Excel

Anonim

Uphawu alulingani neMicrosoft Excel

Ukuba loo miqondiso yothelekiso efana "nangaphezulu" (>) kunye "kancinane" (ukubhala uphawu "kungalingani"

Okokuqala, kuya kufuneka uthi ukuba kukho oonobumba ababini "bangalingani" nge-Presele: "" ≠ ". Eyokuqala isetyenziselwa ukubala, kwaye okwesibini ngokukodwa kumboniso we-program.

Isimboli ""

Inqaku elithi "" lisetyenziswa kwiifomula ezisengqiqweni ze-Excel, xa kufuneka kubonakalise ukungalingani kweempikiswano. Nangona kunjalo, inokusetyenziselwa ukubonwa kwembonakalo, njengoko kusebenza ngakumbi.

Mhlawumbi, abaninzi sele beyiqonda into yokuba ukuze batyeshe uphawu "", kufuneka ukufowuna ngokukhawuleza uphawu "() kwikhibhodi. Ngenxa yoko, kuyavela loo mbhalo: ""

Uphawu alulingani neMicrosoft Excel

Kukho olunye ukhetho lweseti yale nto. Kodwa, phambi kwale ndoda yangaphambili, ngokuqinisekileyo iya kubonakala ingalunganga. Kunokwenzeka kuphela ukuba uyisebenzise ukuba ngenxa yaso nasiphi na isizathu sokuba ikhibhodi ikhubazeke.

  1. Sibonisa iseli apho uphawu lufanele lubhalwe. Yiya kwi "Faka" ithebhu. Kwiteyiphu kwi "Sys" Ibloko yesixhobo esibonisa iqhosha ngegama "uphawu".
  2. Ifestile yokhetho yeSomqondiso ivula. Into "ye-itin ephambili kufuneka iboniswe kwiparameter" esetiweyo ". Kwinxalenye ephakathi yefestile kukho inani elikhulu lezinto ezahlukeneyo, phakathi kwazo zonke izinto ezikhoyo kwikhibhodi yePC esemgangathweni. Ukufowuna "Ukulingana" Sign, cofa kuqala kwi "" iqhosha kwaye kwakhona kwi "Paste". Emva kokuba loo windows ifakwe kungavalwa ngokucinezela umnqamlezo omhlophe kwimvelaphi ebomvu kwikona ephezulu ngasekhohlo.

Ifestile yesimboli kwi-Microsoft Excel

Ke, umsebenzi wethu uzalisekile ngokupheleleyo.

Isimboli "≠"

"I-" ≠ "uphawu lusetyenziswa ngokukodwa kwiinjongo ezibonakalayo. Ifomula kunye nezinye ukubala kwi-Excel akunakwenzeka ukuba ziyisebenzise, ​​kuba isicelo asizi ukuba i-protherator yemathematics.

Ngokungafaniyo "" phawu, unokuphika kuphela "≠" sityikitya usebenzisa iqhosha lekhasethi.

  1. Cofa kwiseli apho kucetywayo ukuyifaka into. Yiya kwi "Faka" ithebhu. Cofa kwindawo ethi "Isimboli" sele sisisi njengesiqhelo kuthi.
  2. Kwifestile evula iparameter "iseti", sichaza "abaqhubi bezibalo". Sikhangela uphawu "≠" kwaye ucofe kuyo. Emva koko cofa iqhosha "Colas". Vala iwindow ngendlela efanayo nexesha elidlulileyo ngokunqakraza emnqamlezweni.

Ukufaka uphawu kwiMicrosoft Excel

Njengoko ubona, into "≠" kwibala leseli kufakwe ngempumelelo.

Isimboli sifakwe kwiMicrosoft Excel.

Sifumanise ukuba zimbini iintlobo zemiqondiso kwi-Excel. Enye yazo iqulathe "encinci" kunye "nemiqondiso" engaphezulu, kwaye isetyenziselwa ikhompyuter. Okwesibini (≠) yinto eyaneleyo, kodwa ukusetyenziswa kwayo kunqongophele kuphela ngokubonwa kokungalingani.

Funda ngokugqithisileyo