Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
crystal
 
Posts: n/a
Default subtract year and divide

how do i subtract years and then divide everytime i do i am not getting the
same answer in my workbook.
  #2   Report Post  
Zack Barresse
 
Posts: n/a
Default subtract year and divide

Hi,

Can you post what your values, formulas, results and desired results are?

--
Regards,
Zack Barresse, aka firefytr, (GT = TFS FF Zack)
To email, remove the NO SPAM. Please keep correspondence to the board, as
to benefit others.


"crystal" wrote in message
...
how do i subtract years and then divide everytime i do i am not getting
the
same answer in my workbook.



  #3   Report Post  
Bob Phillips
 
Posts: n/a
Default subtract year and divide

Bit light on detail here. Do you mean subtract years in two cells, if so,
what happens when it is not exact years? And divide what by what?

--

HTH

RP
(remove nothere from the email address if mailing direct)


"crystal" wrote in message
...
how do i subtract years and then divide everytime i do i am not getting

the
same answer in my workbook.



  #4   Report Post  
Vacation's Over
 
Posts: n/a
Default subtract year and divide

HELP ADD DATES


"Bob Phillips" wrote:

Bit light on detail here. Do you mean subtract years in two cells, if so,
what happens when it is not exact years? And divide what by what?

--

HTH

RP
(remove nothere from the email address if mailing direct)


"crystal" wrote in message
...
how do i subtract years and then divide everytime i do i am not getting

the
same answer in my workbook.




  #5   Report Post  
Zack Barresse
 
Posts: n/a
Default subtract year and divide

I'm confused here. What does "HELP ADD DATES" mean?

--
Regards,
Zack Barresse, aka firefytr, (GT = TFS FF Zack)
To email, remove the NO SPAM. Please keep correspondence to the board, as
to benefit others.



"Vacation's Over" wrote in message
...
HELP ADD DATES


"Bob Phillips" wrote:

Bit light on detail here. Do you mean subtract years in two cells, if so,
what happens when it is not exact years? And divide what by what?

--

HTH

RP
(remove nothere from the email address if mailing direct)


"crystal" wrote in message
...
how do i subtract years and then divide everytime i do i am not getting

the
same answer in my workbook.








  #6   Report Post  
Chip Pearson
 
Posts: n/a
Default subtract year and divide

It means look up 'add dates' in the help file.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com


"Zack Barresse" wrote in message
...
I'm confused here. What does "HELP ADD DATES" mean?

--
Regards,
Zack Barresse, aka firefytr, (GT = TFS FF Zack)
To email, remove the NO SPAM. Please keep correspondence to
the board, as
to benefit others.



"Vacation's Over"
wrote in message
...
HELP ADD DATES


"Bob Phillips" wrote:

Bit light on detail here. Do you mean subtract years in two
cells, if so,
what happens when it is not exact years? And divide what by
what?

--

HTH

RP
(remove nothere from the email address if mailing direct)


"crystal" wrote in
message
...
how do i subtract years and then divide everytime i do i am
not getting
the
same answer in my workbook.







  #7   Report Post  
Bob Phillips
 
Posts: n/a
Default subtract year and divide

I did, but it didn't help me see the question in any clearer light :-))


Bob


"Chip Pearson" wrote in message
...
It means look up 'add dates' in the help file.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com


"Zack Barresse" wrote in message
...
I'm confused here. What does "HELP ADD DATES" mean?

--
Regards,
Zack Barresse, aka firefytr, (GT = TFS FF Zack)
To email, remove the NO SPAM. Please keep correspondence to
the board, as
to benefit others.



"Vacation's Over"
wrote in message
...
HELP ADD DATES


"Bob Phillips" wrote:

Bit light on detail here. Do you mean subtract years in two
cells, if so,
what happens when it is not exact years? And divide what by
what?

--

HTH

RP
(remove nothere from the email address if mailing direct)


"crystal" wrote in
message
...
how do i subtract years and then divide everytime i do i am
not getting
the
same answer in my workbook.









Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
IRR PC Excel Worksheet Functions 3 September 30th 05 03:13 AM
Calculating commission schedule (will pay for help!) bootsy Excel Worksheet Functions 2 October 28th 04 07:24 AM


All times are GMT +1. The time now is 02:39 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"