Ok, thank you for the roundup formula. I did not know it. However, I wanted
to know if somebody has suggested any solution for the number format. If we
use formulas, we have to put them in other cells. A formatting option will
solve the actual problem presented by our friend.
Best regards,
Amiyo Biswas
Cell: 91-9433464329
----- Original Message -----
From: "Mukesh Baviskar" <mukeshbaviskar....@gmail.com>
To: <kamalve...@pnb.co.in>
Cc: "Access India" <accessindia@accessindia.org.in>
Sent: Monday, April 26, 2010 8:43 PM
Subject: Re: [AI] EXCEL FORMULA
Hello,
round off the figure in nearest rupee of 9.03 is 9 and not 10. Whenever
The
figure after decimal is >50 it will round up the nearest figure which 9.
You
may use the 'round' formula for this. For example:
=ROUND(a1,0) IN B1
If you want to change 9.03 to 10 use roundup formula as:
roundup(a1,0)in c1 you will get the answer 10 instead of 9
Try it and solve your problem. If you have any doubt contact me on my
mobile. Thank you.
9.03
9
10
10.1
10
11
10.5
11
11
10.4
10
11
9.09
9
10
Mukesh R. Baviskar
9403161157
----- Original Message -----
From: "Amiyo Biswas" <amiyo.bis...@gmail.com>
To: <accessindia@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....@gmail.com>
To: <accessindia@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" <kamalve...@pnb.co.in>
To: <accessindia@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-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
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
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
--------------------------------------------------------------------------------
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
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
