D
dhmilw
I have a column of dates. If a date falls on 9/1/2008 or later I want 1.5%
to appear in J170. Otherwise I want 0% to appear. I want to use the IF
function. I have written this: =IF(G170>=8/31/2008,"1.5%","0%"). It did not
work. I tried =IF(G170<=9/1/2008, "1.5%","0%"). IN the first case it always
returns 1.5%. The 2nd case returns 0%. The date in cell G170 in both cases is
7/25/2008.
to appear in J170. Otherwise I want 0% to appear. I want to use the IF
function. I have written this: =IF(G170>=8/31/2008,"1.5%","0%"). It did not
work. I tried =IF(G170<=9/1/2008, "1.5%","0%"). IN the first case it always
returns 1.5%. The 2nd case returns 0%. The date in cell G170 in both cases is
7/25/2008.