Results 1 to 8 of 8

Thread: Excel: IF DATE

Hybrid View

Previous Post Previous Post   Next Post Next Post
  1. #1
    ;) vassil_dinkov's Avatar
    Join Date: Nov:2004
    Location:
    Posts: 186

    Excel: IF DATE

    ,
    :

    .. :
    =IF(E6="";IF(A6>=DATE(2006;1;1);IF (B6<=DATE(2006;12;31);1,3298;IF(A6>=DATE (2007;1;1);IF(B6<=DATE(2007;12;31);1,419 8;IF(A6>=DATE(2008;1;1);IF(B6<=DATE(2008 ;12;31);1,5721))))));1,95583)

    IF(A6>=DATE(2009;1;1);IF(B6<=DATE(2009;1 2;31);1,5666; DATE. .. 3. 4.. . ?

    , .. , / / .

    Click image for larger version. 

Name:	excel.jpg 
Views:	71 
Size:	31.5 KB 
ID:	88731
    MB: GA MA69GM-S3H / CPU: Sempron64 3200+ 1.8@3.0Ghz / RAM: 21GB PQI DDR2 800@1000 / VC: Chaintech 7900GS 256mb/256bit / HDD: Hitachi Sata II 250GB /

  2. #2
    -==-
    Join Date: Sep:2003
    Location:
    Posts: 6,444
    Quote Originally Posted by vassil_dinkov View Post
    ... ?...
    . .
    He who asks is a fool for five minutes, but he who does not ask reamins a fool forever. Old Chinese saying
    Quote Originally Posted by worm4 View Post
    a .

  3. #3
    ;) vassil_dinkov's Avatar
    Join Date: Nov:2004
    Location:
    Posts: 186
    Quote Originally Posted by Yasen6275 View Post
    . .
    .. .. ..

    Click image for larger version. 

Name:	excel 2.jpg 
Views:	30 
Size:	38.3 KB 
ID:	88732
    MB: GA MA69GM-S3H / CPU: Sempron64 3200+ 1.8@3.0Ghz / RAM: 21GB PQI DDR2 800@1000 / VC: Chaintech 7900GS 256mb/256bit / HDD: Hitachi Sata II 250GB /

  4. #4
    Registered User
    Join Date: Sep:2003
    Location: Where you live
    Posts: 976
    =IF(E6=""; IF(A6>=DATE(2006;1;1); IF (B6<=DATE(2006;12;31);1,3298; IF(A6>=DATE(2007;1;1); IF(B6<=DATE(2007;12;31);1,4198; IF(A6>=DATE(2008;1;1); IF(B6<=DATE(2008;12;31);1,5721; IF(A6>=DATE(2009;1;1); IF(B6<=DATE(2009;12;31);1,5666)))))));1, 95583))

    2013 :

    =IF(E6=""; IF(A6>=DATE(2006;1;1); IF (B6<=DATE(2006;12;31);1,3298; IF(A6>=DATE(2007;1;1); IF(B6<=DATE(2007;12;31);1,4198; IF(A6>=DATE(2008;1;1); IF(B6<=DATE(2008;12;31);1,5721; IF(A6>=DATE(2009;1;1); IF(B6<=DATE(2009;12;31);1,5666; IF(A6>=DATE(2010;1;1); IF(B6<=DATE(2010;12;31);1,5666; IF(A6>=DATE(2011;1;1); IF(B6<=DATE(2011;12;31);1,5666; IF(A6>=DATE(2012;1;1); IF(B6<=DATE(2012;12;31);1,5666; IF(A6>=DATE(2013;1;1); IF(B6<=DATE(2013;12;31);1,5666; )))))));1,95583))))))))))

    ,
    Last edited by dzk; 14th April 2017 at 19:02.

  5. #5
    Banned
    Join Date: Mar:2017
    Location: Bulgaria
    Posts: 96
    AND.

    =IF(E6="";IF(AND(A6>=DATE(2006,1,1 ),B6<=(DATE(2006,12,31))),B3,IF(AND(A6>= DATE(2007,1,1),B6<=DATE(2007,12,31)),C3, D3));1,95583) .


    B3, C3, D3 - ()
    Last edited by tougi; 14th April 2017 at 21:43.

  6. #6
    Registered User
    Join Date: Oct:2003
    Location:
    Posts: 4,317
    , . - , VLOOKUP. , YEAR() VLOOKUP - , 1,5666.
    , , . , .

  7. #7
    Banned
    Join Date: Mar:2017
    Location: Bulgaria
    Posts: 96
    VLOOKUP .

    / - INDEX + MATCH

    : (111)
    =INDEX(DataQuantity,MATCH(E111,DataOrder ,0),1)

    (DataOrder) (DataQuantity).

    Insert -> Name -> Define .

  8. #8
    ;) vassil_dinkov's Avatar
    Join Date: Nov:2004
    Location:
    Posts: 186
    !

    Quote Originally Posted by bsb View Post
    . , YEAR()
    ..

    =IF(E3="";IF(YEAR(A3)=2006;2006;IF (YEAR(A3)=2007;2007;IF(YEAR(A3)=2008;200 8;IF(YEAR(A3)=2009;2009;IF(YEAR(A3)=2010 ;2010;IF(YEAR(A3)=2011;2011;IF(YEAR(A3)= 2012;2012;IF(YEAR(A3)=2013;2013;IF(YEAR( A3)=2014;2014;IF(YEAR(A3)=2015;2015;IF(Y EAR(A3)=2016;2016))))))))));1,95583)


    a o VLOOKUP.. - ,

    =IF(E6="";VLOOKUP(A6;kurs06;2);1,9 5583)

    , , 2003, 4 , 2010 .
    Last edited by vassil_dinkov; 16th April 2017 at 09:53.
    MB: GA MA69GM-S3H / CPU: Sempron64 3200+ 1.8@3.0Ghz / RAM: 21GB PQI DDR2 800@1000 / VC: Chaintech 7900GS 256mb/256bit / HDD: Hitachi Sata II 250GB /

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 |