excelda formulalar

PDF 2 pages 166.1 KB Free download

2 pages

FaylHub.uz

Download via Telegram

Size 166.1 KB

File type PDF

Pages 2

Updated Dec 2025

Page preview (2 pages)

Scroll down 👇

1 / 2

matematik funksiyalar telegram: @infoedu_uz matematik funksiyalar exceldagi nomi bajaradigan vazifasi misollar abs (son) sonning absolyut qiymatini, ya’ni modulini hisoblaydi abs(–274)=274; abs(48)=48; abs(–12,03)=12,03; abs(0)=0 znak (son) agar son musbat bo‘lsa 1 ga, nol bo‘lsa 0 ga, manfiy bo‘lsa –1 ga almashtiradi zhak(208)=1; zhak(3,6)=1; znak(0)= 0; zhak(–75)=–1 kopeh (son) sonni kvadrat ildizdan chiqaradi kopeh(4)=2; kopeh(121)=11; kopeh(0,04)=0,2 okrugl (son; xona) sonni kasr qismidagi razriyadlar soni bo‘yicha yaxlitlash okrugl(1,2345;2)=1,23; okrugl(4,9067;3)=4,907 octat (son; bo‘luvchi) bo‘linuvchini bo‘luvchiga bo‘lgandagi qoldiqni chiqaradi octat(45;7)=3; octat(15;3)=0; octat(–191;10)=9 stepen (son; daraja ko‘rsatkichi) sonni darajaga ko‘taradi stepen(3;4)=81; stepen(2;10)=1024; stepen(–2;3)=8; stepen(10;6)=1000000 cumm (son 1; son 2; ...) katakchalar blokidagi qiymatlarning yig‘indisini hisoblaydi cumm(1;2;3)=6; cumm(31;70)=101; cumm(8;–7)=1; cumm(–100;70)=–30 proizved (son; son; ...) berilgan sonlar ko‘paytmasining qiymatini aniqlaydi proizved(6;7)=42; proizved(–10;9)=–90 tseloe (son) kichik butun songa yaxlitlaydi tseloe(5,8)=5; tseloe(–5,6)=–6; tseloe(10,3)=10 mantiqiy funksiyalar i (mantiqiy ifodalar; mantiqiy ifoda 2; ...) agar mantiqiy ifodalar barchasining qiymati rost bo‘lsa, funksiyaning qiymati rost (istina), aks holda funksiyaning qiymati yolg‘on (loj) i(500>5*100)=yolg‘on; …

2 / 2

on1, son2, ... larning eng katta qiymatini aniqlaydi makc(1; 2; –9)=2; makc(59; 204; 1011)=1011 min (son1; son2; ...) son1, son2, ... larning eng kichik qiymatini aniqlaydi min(1; 2; –7)=–7; min(107; 25; 24)=24 cpzhach (sonl; son2; ...) son1, son2, ... larning o‘rta arifmetik qiymatini aniqlaydi cpzhach(1; 2; 6)=3; cpzhach(–1; –2; 6; 7; 0)=2 schyotesli ( blok; shart) berilgan diapazondagi, shartni qanoatlantiruvchi blokning bo‘sh bo‘lmagan katakchalari sonini sanaydi schyotesli(a1:a3;1)=2; a1=1. a2=2. a3=1 schyotesli($a$2:$a$13;g2)=12 matnli funksiyalar dlstr (matn) matndagi belgilar sonini aniqlaydi dlstr(@infoedu_uz)=11; dlstr(3,1415)=6; dlstr(azimjon quvanov)=15 zamenit (eski matn; qaysi o'rindan; nechtasi o‘rniga; yangi matn) eski matnning belgilarini ko'rsatilgan joydan boshlab “berilgan son”ta belgilarini yangi matnga almashtiradi zamenit(“men”; 3;1;“hr”) =“mehr” zamenit(“men”; 2;2;“uz”) = “muz” zhacheh (matn) matn ko‘rinishidagi sonni songa o‘tkazadi znachen(“1024,25”)=1024,25; znachen(“504”)=504 jlebcimb (matn; belgilar soni) matnning chap tomonidan n ta belgisini ajratib oladi levsimv("gulnoza";3)= "gul" pravsimv(matn; belgilar soni) matnning o‘ng tomonidan n ta belgisini ajratib oladi pravsimv("informatika";6)= "matika" stsepit (matn1; matn2; …

Want to read more?

Download all 2 pages for free via Telegram.

Download full file

About "excelda formulalar"

matematik funksiyalar telegram: @infoedu_uz matematik funksiyalar exceldagi nomi bajaradigan vazifasi misollar abs (son) sonning absolyut qiymatini, ya’ni modulini hisoblaydi abs(–274)=274; abs(48)=48; abs(–12,03)=12,03; abs(0)=0 znak (son) agar son musbat bo‘lsa 1 ga, nol bo‘lsa 0 ga, manfiy bo‘lsa –1 ga almashtiradi zhak(208)=1; zhak(3,6)=1; znak(0)= 0; zhak(–75)=–1 kopeh (son) sonni kvadrat ildizdan chiqaradi kopeh(4)=2; kopeh(121)=11; kopeh(0,04)=0,2 okrugl (son; xona) sonni kasr qismidagi razriyadlar soni bo‘yicha yaxlitlash okrugl(1,2345;2)=1,23; okrugl(4,9067;3)=4,907 octat (son; bo‘luvchi) bo‘linuvchini bo‘luvchiga bo‘lgandagi qoldiqni chiqaradi octat(45;7)=3; octat(15;3)=0; octat(–191;10)=9 stepen (son; daraja ko‘rsatkichi) sonni darajaga ko‘taradi stepen(3;4)=81; stepen(2;10)=102...

This file contains 2 pages in PDF format (166.1 KB). To download "excelda formulalar", click the Telegram button on the left.

Tags: excelda formulalar PDF 2 pages Free download Telegram