[AI] EXCEL FORMULA

Amiyo Biswas amiyo.biswas at gmail.com
Mon Apr 26 20:49:40 EDT 2010


Hello Kamal,

How was it solved? You wanted a format option and I did not notice if 
anybody suggested any suggestion on format option. We were all discussing 
formulas.
Best regards,
Amiyo Biswas
Cell: 91-9433464329


----- Original Message ----- 
From: "Kamal Verma" <kamalverma at pnb.co.in>
To: <accessindia at accessindia.org.in>
Sent: Monday, April 26, 2010 11:00 AM
Subject: Re: [AI] EXCEL FORMULA


> Hello!
>
> Thanks to all for their valuable suggestions. My problem is solved now.
>
> Kamal Verma.
> ----- Original Message ----- 
> From: "Surya Prakash Sharma" <surya.sharma26 at gmail.com>
> To: <accessindia at accessindia.org.in>
> Sent: Monday, April 26, 2010 6:43 AM
> Subject: Re: [AI] EXCEL FORMULA
>
>
>> hi,
>> 9.00 is the nearest round off of 9.03. so one should not expect 10 from 
>> the formula.
>> ----- Original Message ----- 
>> From: "Amiyo Biswas" <amiyo.biswas at gmail.com>
>> To: <accessindia at accessindia.org.in>
>> Sent: Monday, April 26, 2010 6:18 AM
>> Subject: Re: [AI] EXCEL FORMULA
>>
>>
>>> 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
>>>
>>>
>>>
>>>
>>> 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
>>
>
>
>
> 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 





More information about the AccessIndia mailing list