If column D is after year 2010 quick question
Closed
Chip
-
Dec 14, 2010 at 06:21 PM
venkat1926 Posts 1863 Registration date Sunday June 14, 2009 Status Contributor Last seen August 7, 2021 - Dec 16, 2010 at 08:41 PM
venkat1926 Posts 1863 Registration date Sunday June 14, 2009 Status Contributor Last seen August 7, 2021 - Dec 16, 2010 at 08:41 PM
Related:
- If column D is after year 2010 quick question
- Microsoft office 2010 free download - Download - Office suites
- Microsoft publisher 2010 free download - Download - Publishing
- Pdf and xps add in 2010 - Download - Other
- Quick cpu - Download - Diagnosis and monitoring
- Yahoo mail forgot password and security question - Guide
2 responses
venkat1926
Posts
1863
Registration date
Sunday June 14, 2009
Status
Contributor
Last seen
August 7, 2021
811
Dec 15, 2010 at 04:12 AM
Dec 15, 2010 at 04:12 AM
what did you enter in D1(remember it is not D but D1 a cekk)
is it "year 2010"
or
2010
or
1/1/2010
and format it only as year.
I suppose you have just entered the number 2010 (not date and not string with a word before )
in K1 you type or copy this formula
=IF(D1=2010,D1/6,IF(D1>2010,D1/3,""))
is it "year 2010"
or
2010
or
1/1/2010
and format it only as year.
I suppose you have just entered the number 2010 (not date and not string with a word before )
in K1 you type or copy this formula
=IF(D1=2010,D1/6,IF(D1>2010,D1/3,""))
venkat1926
Posts
1863
Registration date
Sunday June 14, 2009
Status
Contributor
Last seen
August 7, 2021
811
Dec 16, 2010 at 08:41 PM
Dec 16, 2010 at 08:41 PM
if the entry is as mm/dd/yy and formatted as d/m/yyyy in cell D1 then
=year(D1) gives 2010
the formula will be
=if(year(d1)=2010,E1/6,if(year(D1)>2010,E1/3,""))
if you enter any date in D1 in the year 2010 it will give E1(repeat E1) divided by 6
if the year is later than 2010 it will give E1/3.
=year(D1) gives 2010
the formula will be
=if(year(d1)=2010,E1/6,if(year(D1)>2010,E1/3,""))
if you enter any date in D1 in the year 2010 it will give E1(repeat E1) divided by 6
if the year is later than 2010 it will give E1/3.
Dec 16, 2010 at 07:05 PM