Results 1 to 5 of 5

Hybrid View

Previous Post Previous Post   Next Post Next Post
  1. #1
    Registered User marto96's Avatar
    Join Date: May:2008
    Location: Ñîôèÿ
    Posts: 2,211

    Öåëî÷èñëåíî äåëåíèå â Excel èëè íåùî òàêîâà.

    Çäðàâåéòå. Äàñêàëèöàòà íè äàäå çàäà÷êà äà âúâåäåìå 20 ÅÃÍ-òà â Excel è ïîñëå â ñúñåäíàòà êîëîíêà äà ñå èçïèøå "0" çà ìúæ è "1" çà æåíà. Ïðåäïîñëåäíàòà öèôðà îò ÅÃÍ-òî ïîêàçâà ïîëà - àêî å ÷åòíî ÷èñëî, òî èíäèâèäúò å îò ìúæêè ðîä, àêî å íå÷åòíî å îò æåíñêè ðîä. Äåìåê ïî íàêàêúâ íà÷èí òðÿáâà äà ñå ðàçäåëè òàÿ öèôðà çà äà âèäè äàëè å ÷åòíà è ñúîòâåòíî â ñúñåäíàòà êîëîíêà äà ñå èçïèøå 0 èëè 1. Ïèòàì ãîñïîæàòà - ñ öåëî÷èñëåíî äåëåíèå ùå ñòàíå ëè, òÿ ìè êàçà - äà. Ïèòàõ ÿ äàëè ùå ñòàíå ñ MOD, òÿ ïàê êàçà äà. Å 40 ìèíóòè ñè áëúñêàõ ãëàâàòà êàê äà ãî íàïðàâÿ, íî ðåçóëòàò - íèêàêúâ. Ïðèëàãàì è ôàéëà è áëàãîäàðÿ ïðåäâàðèòåëíî.

    EGN.rar
    ASRock B450M Pro4 / 5700X@4.5GHz / MSI RX 6600 XT Mech 2X / be quiet! Dark Rock 4 / 2x16GB FlareX 3200MHz CL16 / FSP Hydro G Pro 1000W / Samsung Odyssey G5 S27AG50

  2. #2
    Registered User kolumb's Avatar
    Join Date: Aug:2006
    Location: Burgas
    Posts: 1,582
    Ôóíêöèÿ ISODD
    Code:
    Îïèñàíèå
    Âðúùà TRUE, àêî ÷èñëî å íå÷åòíî, èëè FALSE, àêî ÷èñëî å ÷åòíî.
    Ïîñëå IF/ELSE
    Code:
    Syntax
    
    The syntax for the nesting the IF function is:
    
    IF( condition1, value_if_true1, IF( condition2, value_if_true2, value_if_false2 ))
    This would be equivalent to the following IF THEN ELSE statement:
    
    IF condition1 THEN
       value_if_true1
    THEN
       value_if_true2
    ELSE
       value_if_false2
    END IF
    Îòíå ìè êúì 20 ñåê äà ãî íàïèøà ñ åäèí ïðúñò â ãîîãëåòî
    Desktop - Ryzen 5 5600X, Asus Prime B500-Plus, Asus Strix RX 6600XT OC, 2x16GB Crusial Ballistix DDR4-3200, Corsair MP600 500GB M2.Gen 4.0x4, SEASONIC Focus Plus SSR-650FX, Corsair Carbide 270R, HP Z24i

  3. #3
    Registered User
    Join Date: Aug:2009
    Location: Ñîôèÿ
    Posts: 265
    Code:
    =IF(MOD(MID(B3;9;1);2)=0;"0";"1")

  4. #4
    Registered User kolumb's Avatar
    Join Date: Aug:2006
    Location: Burgas
    Posts: 1,582
    Code:
    =IF(ISODD(MID(B3,9,1)),1,0)
    À òîâà ïðàâè ïðîâåðêà è àêî íÿìà âúâåäåíî ÅÃÍ, íå èçïèñâà íèùî.
    Code:
    =IF(B3,IF(ISODD(MID(B3,9,1)),1,0),"")
    Desktop - Ryzen 5 5600X, Asus Prime B500-Plus, Asus Strix RX 6600XT OC, 2x16GB Crusial Ballistix DDR4-3200, Corsair MP600 500GB M2.Gen 4.0x4, SEASONIC Focus Plus SSR-650FX, Corsair Carbide 270R, HP Z24i

  5. #5
    Registered User marto96's Avatar
    Join Date: May:2008
    Location: Ñîôèÿ
    Posts: 2,211
    Áëàãîäàðÿ.
    ASRock B450M Pro4 / 5700X@4.5GHz / MSI RX 6600 XT Mech 2X / be quiet! Dark Rock 4 / 2x16GB FlareX 3200MHz CL16 / FSP Hydro G Pro 1000W / Samsung Odyssey G5 S27AG50

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

Copyright © 1999-2011 Õàðäóåð ÁÃ. Âúçìîæíî å ñúäúðæàíèåòî íà òàçè ñòðàíèöà äà å îáåêò íà àâòîðñêè ïðàâà.
iskamPC.com | mobility.BG | Bloody's Techblog | Êðèïòîâàëóòè è ìàéíèíã | 3D Vision Blog | Ìàãàçèí çà åëåêòðîííè öèãàðè