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
0
how do yo figure out the general value of a date?
0
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
0
i just tried that. turns out that the general value is also 31/5/2007.
0

Didn't find the answer you are looking for?

Ask a question
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
0
none of it is working.
0
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"
3) Open notepad (NOT WORD, it has to be notepad)
4) Paste your data into notepad.
5) In notepad, press CTRL + A (selects all cells) then press CTRL + C (copies data)
6) Paste data back into Excel.
7) It will say something about size not being the same, paste it anyways.

after that you can check general value.
0