Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Help with dates!! Excel 2003 | Excel Discussion (Misc queries) | |||
Dates in Excel 2003 | Excel Discussion (Misc queries) | |||
Dates in Excel 2003 | Excel Discussion (Misc queries) | |||
Excel 2003 dates | Excel Discussion (Misc queries) | |||
dates in Excel 2003 | Excel Discussion (Misc queries) |