-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ Round off in multiple of 25 paise!
And this one too =MROUND(A1-0.25/2,0.25)
Regards,
Sam Mathai Chacko
On Wed, Apr 17, 2013 at 10:28 PM, Kanwaljit Singh wrote:
> Much Better Paul :)
>
>
> On Wed, Apr 17, 2013 at 10:24 PM, Pa
----------
>> *From:* "chhajersand...@gmail.com"
>> *To:* excel-macros@googlegroups.com
>> *Sent:* Wed, April 17, 2013 12:26:39 PM
>> *Subject:* $$Excel-Macros$$ Round off in multiple of 25 paise!
>>
>> Dear Expert,
>>
>> I want a
eople you can,
> As long as ever you can.” - John Wesley
> *-
>
>
> --
> *From:* "chhajersand...@gmail.com"
> *To:* excel-macros@googlegroups.com
> *Sent:* Wed, April 17, 2013 12:26:39 PM
> *Subject:* $$Excel-Macros$$ Round off in multiple of 25 paise!
>
> Dear Expert
6:39 PM
Subject: $$Excel-Macros$$ Round off in multiple of 25 paise!
Dear Expert,
I want a formula where decimal will rounded off in multiple of 0.25 paise.
Like if amount is between 100.00 to 100.24 it will show 100.00.
if amount is between 100.25 to 100.49 it will show 100.25.
if amount is be
=INT(A1)+ROUNDDOWN((A1-INT(A1))*4,0)/4
Where A1 contains the value.
On Wed, Apr 17, 2013 at 9:56 PM, wrote:
> Dear Expert,
>
> I want a formula where decimal will rounded off in multiple of 0.25 paise.
>
> Like if amount is between 100.00 to 100.24 it will show 100.00.
> if amount is between 10
Dear Expert,
I want a formula where decimal will rounded off in multiple of 0.25 paise.
Like if amount is between 100.00 to 100.24 it will show 100.00.
if amount is between 100.25 to 100.49 it will show 100.25.
if amount is between 100.50 to 100.74 it will show 100.50.
if amount is between 100.75
