Results 1 to 23 of 23

Thread: Excel, ...

Hybrid View

Previous Post Previous Post   Next Post Next Post
  1. #1
    Registered User
    Join Date: Oct:2005
    Location: mars
    Posts: 266

    Excel, ...

    k if(A1:A3>4; "ok"; "no") ,
    ...

  2. #2
    Registered User
    Join Date: Jun:2005
    Location:
    Posts: 62
    =IF(SUM(A1:A3)>4;"Da";"Ne")

  3. #3
    Registered User mertol's Avatar
    Join Date: Jan:2011
    Location: sofia
    Posts: 2,927
    1 3 4, -. - IF(MAX(A1:3)>4;"ok";"no")
    Asrock B365 Pro4; Intel Core i5-9400F; Kingston HyperX 2x16Gb DDR4; Gigabyte Aorus GTX 1080ti

  4. #4
    Registered User
    Join Date: Oct:2005
    Location: mars
    Posts: 266
    Quote Originally Posted by mertol View Post
    1 3 4, -. - IF(MAX(A1:3)>4;"ok";"no")
    ,

  5. #5
    Registered User CYPER's Avatar
    Join Date: May:2004
    Location:
    Posts: 9,356
    ?

    .

    Gigabyte X570 AORUS Ultra | 5950X | Arctic Liquid Freezer II 240 | Corsair Vengeance LPX 2x8GB 3200Mhz | Samsung 980 Pro 1TB + Samsung 970 Pro 1TB | Gigabyte AORUS GeForce RTX 3080 Ti Master 12GB | Fractal Design Meshify C Dark TG | Corsair AX860i | Samsung U32H850 32" 4K

  6. #6
    Registered User mertol's Avatar
    Join Date: Jan:2011
    Location: sofia
    Posts: 2,927
    , , . :
    =VALUE(LEFT(A1;FIND("m";A1)-1))+VALUE(MID(A1;FIND("m";A1)+2;FIND("s" ;A1)-FIND("m";A1)-2))/60
    Asrock B365 Pro4; Intel Core i5-9400F; Kingston HyperX 2x16Gb DDR4; Gigabyte Aorus GTX 1080ti

  7. #7
    Come get some! DukeFan's Avatar
    Join Date: Jan:2003
    Location:
    Posts: 1,763
    "A1:A3>4"? - ( OR), - ( AND), - ( e}{treme), ().

    : 3-4 max/min - .

  8. #8
    Registered User mertol's Avatar
    Join Date: Jan:2011
    Location: sofia
    Posts: 2,927
    AND OR . - MAX MIN.
    Asrock B365 Pro4; Intel Core i5-9400F; Kingston HyperX 2x16Gb DDR4; Gigabyte Aorus GTX 1080ti

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 |