good reply
manish
- Original Message
From: Ayushj
To: MS EXCEL AND VBA MACROS
Sent: Wed, October 14, 2009 8:36:33 AM
Subject: $$Excel-Macros$$ Re: Plz help in this problem (excel)
Hi Abdul,
You can use ceiling function to get the desired output.
CEILING(number,significance
thanks a lot
On Wed, Oct 14, 2009 at 9:35 AM, vidyut more wrote:
>
>
> use mround formula for output plz find attachment
>>
>>
>> Input 120=mround,5) 121 122123 124 125 126127 128 129 130
>>
>>
>>
>> i want output in this way by using round formula
>>
>> output 120 120 120125 125 125 125125
Hi Abdul,
You can do this using the MRound function. Example:
Cell A1=120
Formula: =MBOUND(A1,5)
here 5 means to the nearest 5. If you want the numbers to the nearest 10 then
the formula would be:
=MBOUND(A1,10)
Thanks,
Amitabh
Date: Tue, 13 Oct 2009 23:21:10 +0500
Subje
use mround formula for output plz find attachment
>
>
> Input120=mround,5)121122123124125126127128129130
>
>
>
> i want output in this way by using round formula
>
> output120120120125125125125125130130130
>
>
> plz send solution of this problem
> Thanx in advance
>
> Regards,
> Abdul Rasheed
>
Hi Abdul,
You can use ceiling function to get the desired output.
CEILING(number,significance)
Example,
=CEILING(121, 5) Rounds 121 up to nearest multiple of 5 i.e. 120
Let me know if it resolve your problem.
Best regards,
Ayush Jain
On Oct 13, 11:21 pm, Abdul Rasheed wrote:
> can any bod
