Previous Topic Next Topic

If column D is after year 2010 quick question

Closed
Report
-
Posts
1864
Registration date
Sunday June 14, 2009
Status
Contributor
Last seen
August 7, 2021
 -
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!

2 replies

Answer 1 / 2
Posts
1864
Registration date
Sunday June 14, 2009
Status
Contributor
Last seen
August 7, 2021
 803
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,""))
Report

the date is in 1/1/2010 format and excel can't look at that and evalute it. it keeps saying it's false.
Answer 2 / 2
Posts
1864
Registration date
Sunday June 14, 2009
Status
Contributor
Last seen
August 7, 2021
 803
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.
Ask a question