Frnd,
You can use this formula =round(A1,-2), then it will convert to nearest 100.
On Wed, Jun 24, 2009 at 10:53 AM, Dilip Pandey dilipan...@gmail.com wrote:
Hi ddp,
It is not as big as you have presented. Try the below formula and you will
have the required result.
=+MROUND(A3,100)
Hi ddp,
It is not as big as you have presented. Try the below formula and you will
have the required result.
=+MROUND(A3,100)
'where A3 is the reference
I have tested this on a workbook and same is attached herewith for your
reference.
Thanks,
Dilipandey
--
DILIP KUMAR PANDEY
MBA-HR,B
, 24 Jun 2009 13:23:51 +0530
Subject: $$Excel-Macros$$ Re: Plz. Help: Convert complex figures into higher
or lower 00 Figures
From: dilipan...@gmail.com
To: excel-macros@googlegroups.com
Hi ddp,
It is not as big as you have presented. Try the below formula and you will
have the required
Dear ,
use function @MROUND(FIGURE,50)
DEEPAK
On 6/23/09, Dharmendra Kumar dharmendrakumar...@gmail.com wrote:
Hi members,
Hope you all are doing well.
Please help me with a solution which, I am sure, will benefit others too.
Problem: It is very difficult to remember tones of
Hi Dharmendra,
You can use built in MRound Function in Excel.
If Cell A1 have value of 2723, MRound(A1,100) Would give you 2700.
Regards,
Upendra Singh
9910227325
-
There are 10
$$ Re: Plz. Help: Convert complex figures into
higher or lower 00 Figures
From: dilipan...@gmail.com
To: excel-macros@googlegroups.com
Hi ddp,
It is not as big as you have presented. Try the below formula and you will
have the required result.
=+MROUND(A3,100)
'where A3 is the reference
happening please?
Regards - Dave.
--
Date: Wed, 24 Jun 2009 13:23:51 +0530
Subject: $$Excel-Macros$$ Re: Plz. Help: Convert complex figures into
higher or lower 00 Figures
From: dilipan...@gmail.com
To: excel-macros@googlegroups.com
Hi ddp,
It is not as big
gud
2009/6/24 Deepak Gupta dpk1...@gmail.com
Dear ,
use function @MROUND(FIGURE,50)
DEEPAK
On 6/23/09, Dharmendra Kumar dharmendrakumar...@gmail.com wrote:
Hi members,
Hope you all are doing well.
Please help me with a solution which, I am sure, will benefit others too.
Thanks Deepak..this will help..
Regd,
Dharmendra
On 6/24/09, MOKSH.. krishna.ange...@gmail.com wrote:
gud
2009/6/24 Deepak Gupta dpk1...@gmail.com
Dear ,
use function @MROUND(FIGURE,50)
DEEPAK
On 6/23/09, Dharmendra Kumar dharmendrakumar...@gmail.com wrote:
Hi members,
Use this formula:
=ROUND(A8;-2)
2009/6/23 ddp dharmendrakumar...@gmail.com
Hi members,
Hope you all are doing well.
Please help me with a solution which, I am sure, will benefit others
too.
Problem:It is very difficult to remember tones of figures
Solution: It is
10 matches
Mail list logo