Hello Sir, You can use ceiling function from excel to get your desired output , Just try below syntax.
Suppose your cell A1 has a value then =CEILING(A1,1) This will convert your value to next higher integer , Just give a try. Hope this helps , Thanks. With best regards Saidarshan Bhagat. Siemens Information Systems Ltd. Gaa Central Functions. Project Monitoring 130 Pandurang Budhkar Marg, Worli Mumbai 400 018. Tell : +91 22 2495 7653. Mobile : +91 9820 223489. Mail to saidarshan.bha...@siemens.com www.siemens.co.in -----Original Message----- From: accessindia-boun...@accessindia.org.in [mailto:accessindia-boun...@accessindia.org.in] On Behalf Of Kamal Verma Sent: Thursday, April 22, 2010 11:29 AM To: accessindia@accessindia.org.in 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-requ...@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 Important notice: This e-mail and any attachment there to contains corporate proprietary information. If you have received it by mistake, please notify us immediately by reply e-mail and delete this e-mail and its attachments from your system. Thank You. To unsubscribe send a message to accessindia-requ...@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