Using dates in Excel 2003
 

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.
--
dhmilw

Using dates in Excel 2003
 

Use

If you want it to be real numerical percentage use

=IF(G170=DATE(2008,8,31),0.015,0)

and format the result as percentage

if you want a text result use


=IF(G170=DATE(2008,8,31),"1.5%","0%")



--


Regards,


Peo Sjoblom





"dhmilw" wrote in message
...
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.
--
dhmilw

Using dates in Excel 2003
 

Thank you. Very helpful. I appreciate that you gave me an option to use text.
My employer wants to see it expressed as "1.5%"
--
dhmilw


"Peo Sjoblom" wrote:

Use

If you want it to be real numerical percentage use

=IF(G170=DATE(2008,8,31),0.015,0)

and format the result as percentage

if you want a text result use


=IF(G170=DATE(2008,8,31),"1.5%","0%")



--


Regards,


Peo Sjoblom





"dhmilw" wrote in message
...
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.
--
dhmilw

Using dates in Excel 2003
 

So use 1.5%, but don't put it in quotes. A string in quotes is a text
string, not a number.
--
David Biddulph

"dhmilw" wrote in message
...
Thank you. Very helpful. I appreciate that you gave me an option to use
text.
My employer wants to see it expressed as "1.5%"
--
dhmilw


"Peo Sjoblom" wrote:

Use

If you want it to be real numerical percentage use

=IF(G170=DATE(2008,8,31),0.015,0)

and format the result as percentage

if you want a text result use


=IF(G170=DATE(2008,8,31),"1.5%","0%")



--


Regards,


Peo Sjoblom





"dhmilw" wrote in message
...
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.
--
dhmilw