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
If column D= year 2010
then column K = column E divided by 6
if column D is after year 2010
then column K =column E divided by 3.

How would I write that in excel for a formula?

Thanks in advanced to anyone who can help me out!
Related:

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
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,""))
the date is in 1/1/2010 format and excel can't look at that and evalute it. it keeps saying it's false.
venkat1926 Posts 1863 Registration date Sunday June 14, 2009 Status Contributor Last seen August 7, 2021 811
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.