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
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.
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.
Related:
- Help me with excel 2003
- Excel mod apk for pc - Download - Spreadsheets
- Gif in excel - Guide
- Kernel for excel - Download - Backup and recovery
- Number to words in excel - Guide
- Save as pdf office 2003 download - Download - Other
7 responses
RWomanizer
Posts
365
Registration date
Monday February 7, 2011
Status
Contributor
Last seen
September 30, 2013
120
Mar 22, 2011 at 02:33 AM
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
=IF(d6<39234,e6*5.15%,e6*10.3%)
39234 is General value of Date 1-Jun-2007
RWomanizer
Posts
365
Registration date
Monday February 7, 2011
Status
Contributor
Last seen
September 30, 2013
120
Mar 22, 2011 at 02:45 AM
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
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
RWomanizer
Posts
365
Registration date
Monday February 7, 2011
Status
Contributor
Last seen
September 30, 2013
120
Mar 22, 2011 at 02:59 AM
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
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
RWomanizer
Posts
365
Registration date
Monday February 7, 2011
Status
Contributor
Last seen
September 30, 2013
120
Mar 22, 2011 at 03:53 AM
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.
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.
