[AI] EXCEL FORMULA

Kamal Verma kamalverma at pnb.co.in
Tue Apr 27 01:33:42 EDT 2010


Hai,

Ceiling function solved my problems. We can use this function in many ways.

Thanks.

Kamal Verma
----- Original Message ----- 
From: "Amiyo Biswas" <amiyo.biswas at gmail.com>
To: <accessindia at accessindia.org.in>
Sent: Tuesday, April 27, 2010 6:19 AM
Subject: Re: [AI] EXCEL FORMULA


> 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
>
>
>
>
> 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. 




More information about the AccessIndia mailing list