Thanx to all experts to answer me about my solution.
Date: Wed, 9 Nov 2011 21:41:55 +0530
Subject: Re: $$Excel-Macros$$ Rounding Method
From: ms.exl.lear...@gmail.com
To: excel-macros@googlegroups.com
Hi Mothilal,
Yours is the exact and simplified solution.
In fact, I forgot that
Hi Mothilal,
Yours is the exact and simplified solution.
In fact, I forgot that function and I was unable to recollect it while
replying to the OP's question. But, your reply helped me to recall it.
Thanks Dude...
---
Ms.Exl.Learner
---
On Wed, Nov 9, 2
use this command
=floor(a1,5)
Mothilal.J[image: image.png]
On Wed, Nov 9, 2011 at 2:10 PM, Advocate kbj wrote:
> Dear Experts,
>
> I want rounding method in excel 2003
> when i typed 124.90 the rounding should come 120 &
> when i typed 125.10 the rounding should come 125 &
> when i type
Hi Sajid,
Refer the reply given to another post for the same subject.
---
Ms.Exl.Learner
---
On Wed, Nov 9, 2011 at 2:10 PM, Advocate kbj wrote:
> Dear Experts,
>
> I want rounding method in excel 2003
> when i typed 124.90 the rounding should come 120 &
Dear Experts,
I want rounding method in excel 2003
when i typed 124.90 the rounding should come 120 &
when i typed 125.10 the rounding should come 125 &
when i typed 129.90 the rounding should come 125
5 digits upward or downward rounding
Regards
Sajid Memon
--
FORUM RULES (925+ members alrea
Hi,
Assume that your input data is A2 cell and apply the below formula in B2
cell.
=A2-MOD(A2,5)
Refer the attachment for details.
---
Ms.Exl.Learner
---
On Wed, Nov 9, 2011 at 2:11 PM, SAJID MEMON wrote:
> Dear Experts,
>
> I want rounding method in
Dear Experts,
I want rounding method in excel 2003
when i typed 124.90 the rounding should come 120 &
when i typed 125.10 the rounding should come 125 &
when i typed 129.90 the rounding should come 125
5 digits upward or downward rounding
Regards
Sajid Memon
