# Help me with excel 2003

Closed
grace - Mar 22, 2011 at 02:23 AM
RWomanizer
Posts
365
Registration date
Monday February 7, 2011
Status
Contributor
Last seen
September 30, 2013
- Mar 22, 2011 at 03:53 AM
hello,

i need some help with excel 2003. i have the date in d6. And an amount in e6. Now, I want the g6 cell to reflect the following values-
a) if the date is up to 31/05/2007, it must be e6*5.15%
b) if the date is anytime after that, it must be e6*10.3%

somebody please gimme the right formula.

## 7 replies

RWomanizer
Posts
365
Registration date
Monday February 7, 2011
Status
Contributor
Last seen
September 30, 2013
120
Mar 22, 2011 at 02:33 AM
Use the following formula in g6:

=IF(d6<39234,e6*5.15%,e6*10.3%)

39234 is General value of Date 1-Jun-2007
how do yo figure out the general value of a date?
RWomanizer
Posts
365
Registration date
Monday February 7, 2011
Status
Contributor
Last seen
September 30, 2013
120
Mar 22, 2011 at 02:45 AM
enter the date
right click on the cell
click format cell
a pop-up window of format cells opened

now click general on the Number tab
it will show you the general value of date
i just tried that. turns out that the general value is also 31/5/2007.

Didn't find the answer you are looking for?

RWomanizer
Posts
365
Registration date
Monday February 7, 2011
Status
Contributor
Last seen
September 30, 2013
120
Mar 22, 2011 at 02:59 AM
the system is not reading it as date,

chage 31/5/2007 as

31/05/2007 if it works that great, otherwise

try in this form

mm/dd/yyyy

means

05/31/2007
none of it is working.
RWomanizer
Posts
365
Registration date
Monday February 7, 2011
Status
Contributor
Last seen
September 30, 2013
120
Mar 22, 2011 at 03:53 AM
Do this:

1) First change your format to the specific date that you want for your column of data.
2) With the column selected, select "Copy"