Hi Experts,
Based on a given number I need the result to be something like below:
Given Number : 200
Answer should be 16 Years 8 Months.
Is there any way of doing it in Ms Excel by Formula?
Thanks,
Ahmed Bawazir
--
FORUM RULES (986+ members already BANNED for violation)
1) Use concise, accu
HI,
Assume data entries in A1, Try below formula,
*
=INT(A1/12)&" Years "&A1-INT(A1/12)*12& " Months"*
On Wed, Jun 13, 2012 at 5:56 AM, Ahmed Honest wrote:
> Hi Experts,
>
> Based on a given number I need the result to be something like below:
>
> Given Number : 200
>
> Answer should be 16 Year
Which months in the 200?
Don Guillett
Microsoft MVP Excel
SalesAid Software
dguille...@gmail.com
From: Ahmed Honest
Sent: Wednesday, June 13, 2012 7:56 AM
To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ No. of years and months
Hi Experts,
Based on a given number I need the result
Hi Maries,
Can you explain me what is this A1-INT(A1/12)*12 does, I mean the math side
explanation. Please explain and Tons of thanks for your solution, it's
working as I need.
Regards
Ahmed Bawazir
On Wed, Jun 13, 2012 at 4:02 PM, Maries wrote:
> HI,
>
> Assume data entries in A1, Try below f
A look in the help index for INT may be of use to you
Don Guillett
Microsoft MVP Excel
SalesAid Software
dguille...@gmail.com
From: Ahmed Honest
Sent: Wednesday, June 13, 2012 8:49 AM
To: excel-macros@googlegroups.com ; talk2mar...@gmail.com
Subject: Re: $$Excel-Macros$$ No. of years and