Results 1 to 8 of 8
Thread: Excel: IF DATE
Hybrid View
-
14th April 2017 17:34 #1
Excel: IF DATE
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 /
-
14th April 2017 17:50 #2-==-
Join Date: Sep:2003
Location:
Posts: 6,444
-
14th April 2017 18:21 #3
-
14th April 2017 18:55 #4Registered 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.
-
14th April 2017 20:17 #5Banned
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.
-
15th April 2017 01:02 #6Registered User
Join Date: Oct:2003
Location:
Posts: 4,317
, . - , VLOOKUP. , YEAR() VLOOKUP - , 1,5666.
, , . , .
-
15th April 2017 13:24 #7Banned
Join Date: Mar:2017
Location: Bulgaria
Posts: 96
VLOOKUP .
/ - INDEX + MATCH
: (111)
=INDEX(DataQuantity,MATCH(E111,DataOrder ,0),1)
(DataOrder) (DataQuantity).
Insert -> Name -> Define .
-
15th April 2017 17:19 #8
!
..
=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 /




Reply With Quote

7th May 2023, 16:02 in PC