Yes sir. I did a small mistake by including "UP" in the formula.
How do I convert numbers in to words? That is if type "123" in A1, I
want "one hundred and twenty three" to be written in B2.
How do I do this?

On 23/03/2012, zoher <[email protected]> wrote:
> stil my formula works in your example .
> ----- Original Message -----
> From: "giri prasad" <[email protected]>
> To: <[email protected]>
> Sent: Friday, March 23, 2012 1:48 PM
> Subject: Re: [AI] Rounding up percentage.
>
>
>> Dear sir, try this and let me know.
>> =16150*35.952%
>> The result will be 5806.248.
>> Now I want to round up this result to 5806 since the value after the
>> decimal point is less than 5.
>> Look forward to hearing from you at the earliest.
>>
>> On 23/03/2012, Mukesh <[email protected]> wrote:
>>> Use this formula as follows:
>>>
>>> =round((a1*0.15),0)
>>>
>>> The cell address may vary as per your cell address. Your problem is
>>> solve.
>>> Please try it.
>>>
>>> Regards
>>>
>>> Mukesh Baviskar
>>> Mobile: 9403161157
>>>
>>> --------------------------------------------------
>>> From: "giri prasad" <[email protected]>
>>> Sent: Thursday, March 22, 2012 7:23 PM
>>> To: <[email protected]>
>>> Subject: [AI] Rounding up percentage.
>>>
>>>> Dear list members, I have a queery related to excel regarding rounding
>>>> up percentage.
>>>> I am not sure whether I will be able to explain it well. I therefore
>>>> will explain it giving an example. For instance if we give the formula
>>>> 1. =25*15% we get 3.75.
>>>> 2. =25*13% we get  3.25.
>>>>
>>>> In the first example, after the decimal point, if the value is greater
>>>> than or equal to 5, I want it to be rounded up to the next digit that
>>>> is 4.
>>>>
>>>> If the value is less than 5 after the decimal point, I want it to be
>>>> rounded to the previous digit that is 3 in the second example.
>>>> How do I do this? I will be grateful if some one can help me out.
>>>>
>>>>
>>>> --
>>>> WITH REGARDS
>>>>
>>>> GIRIPRASAD
>>>>
>>>> MOBILE 924710000   /   9441133367
>>>>
>>>> SKYPE  giriprasad.maddina
>>>>
>>>> "Our greatest glory consists not in never falling,
>>>> but in rising every time we fall."
>>>>
>>>>
>>>> Search for old postings at:
>>>> http://www.mail-archive.com/[email protected]/
>>>>
>>>> To unsubscribe send a message to
>>>> [email protected]
>>>> with the subject unsubscribe.
>>>>
>>>> To change your subscription to digest mode or make any other changes,
>>>> please visit the list home page at
>>>> http://accessindia.org.in/mailman/listinfo/accessindia_accessindia.org.in
>>>>
>>>
>>>
>>> Search for old postings at:
>>> http://www.mail-archive.com/[email protected]/
>>>
>>> To unsubscribe send a message to
>>> [email protected]
>>> with the subject unsubscribe.
>>>
>>> To change your subscription to digest mode or make any other changes,
>>> please
>>> visit the list home page at
>>> http://accessindia.org.in/mailman/listinfo/accessindia_accessindia.org.in
>>>
>>>
>>
>>
>> --
>> WITH REGARDS
>>
>> GIRIPRASAD
>>
>> MOBILE 924710000   /   9441133367
>>
>> SKYPE  giriprasad.maddina
>>
>> "Our greatest glory consists not in never falling,
>> but in rising every time we fall."
>>
>>
>> Search for old postings at:
>> http://www.mail-archive.com/[email protected]/
>>
>> To unsubscribe send a message to
>> [email protected]
>> with the subject unsubscribe.
>>
>> To change your subscription to digest mode or make any other changes,
>> please visit the list home page at
>> http://accessindia.org.in/mailman/listinfo/accessindia_accessindia.org.in
>>
>
>
>
> Search for old postings at:
> http://www.mail-archive.com/[email protected]/
>
> To unsubscribe send a message to
> [email protected]
> with the subject unsubscribe.
>
> To change your subscription to digest mode or make any other changes, please
> visit the list home page at
> http://accessindia.org.in/mailman/listinfo/accessindia_accessindia.org.in
>
>


-- 
WITH REGARDS

GIRIPRASAD

 MOBILE 924710000   /   9441133367

SKYPE  giriprasad.maddina

"Our greatest glory consists not in never falling,
 but in rising every time we fall."


Search for old postings at:
http://www.mail-archive.com/[email protected]/

To unsubscribe send a message to
[email protected]
with the subject unsubscribe.

To change your subscription to digest mode or make any other changes, please 
visit the list home page at
http://accessindia.org.in/mailman/listinfo/accessindia_accessindia.org.in

Reply via email to