[AI] EXCEL FORMULA

Amiyo Biswas amiyo.biswas at gmail.com
Sun Apr 25 20:48:06 EDT 2010


Ok, it's not giving 10 for 9.03, as Kamal wanted.

----- Original Message ----- 
From: "Mukesh Baviskar" <mukeshbaviskar.nsk at gmail.com>
To: <accessindia at accessindia.org.in>
Sent: Sunday, April 25, 2010 7:34 AM
Subject: Re: [AI] EXCEL FORMULA


> Here is the solution for your problem.
> Open excel sheet.
> For example: write 9.03 in a1.
> Go to format menu or simply press the shortcut ctrl + 1 and go to number 
> tab.
> Choose category number-tab-decimal place 0-tab-okay-enter. Copy this 
> format in required column or row. your problem will be solved. Thank you.
>
> Mukesh R. Baviskar
> 9403161157
> ----- Original Message ----- 
> From: "Kamal Verma" <kamalverma at pnb.co.in>
> To: <accessindia at accessindia.org.in>
> Sent: Thursday, April 22, 2010 11:28 AM
> Subject: [AI] EXCEL FORMULA
>
>
>> Hello everyone,
>>
>> I want to round off the figure in nearest rupee. Suppose, I enter 9.03 in 
>> A1, it should appear as 10.00 in the same cell. Further, I enter 99.10 in 
>> B1, it should automatically be changed to 100.
>>
>> Please suggest me any formula or macro in this regard. Though I am well 
>> acquainted  with excel formulae, this exercise is out of my 
>> comprehension.
>>
>> Kamal Verma,
>>
>>
>>
>> DISCLAIMER:
>>
>>
>> The Information transmitted in this email is solely for the addressee. It 
>> is confidential and may be legally privileged. Access to this email by 
>> anyone else is unauthorized. Any disclosure, copying, distribution or any 
>> action taken by anyone other than by the intended recipient is prohibited 
>> and may be unlawful. If you are not the intended recipient then kindly 
>> delete the mail from your system. Any opinion or views expressed in this 
>> mail may not necessarily reflect that of Punjab National Bank. The bank 
>> considers unencrypted email as an insecure mode of communication.
>>
>>
>> To unsubscribe send a message to accessindia-request at accessindia.org.in 
>> 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
>
>
>
>
> To unsubscribe send a message to accessindia-request at accessindia.org.in 
> 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 





More information about the AccessIndia mailing list