Results 1 to 5 of 5

Thread: Excel .

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 |