Can anybody tell how to round off paise nearest to rupee in excel format?

by admin on May 30, 2012

VN:F [1.9.22_1171]
Rating: 0.0/10 (0 votes cast)

Can anybody tell how to round off paise nearest to rupee in excel format, example, 416.75 & 416.45



+Admin


Those who found this page were searching for:

rupees and paise


{ 2 Answers… read them below or add one }

CDV May 30, 2012 at 2:46 am

B4 is value
C4 =IF(MOD(B4*100,100)<50, FLOOR(B4,1),CEILING(B4,1))

Reply

hot-n-cool May 30, 2012 at 2:46 am

There are many options, some of them is given below:

Option A: Format the cell as number or currency without decimal places. For doing so follow this – Format > cell.

Option B: Write in the cell =round(416.75,0), the result will come without decimals, i.e., 417.

Option C: Use functions like Floor or Ceiling.

Option D: for any clarification mail me at [email protected]

Reply

Subscribe to Professional Answers on Investments by Email

Note: You will soon get email from Google Feedburner to confirm your subscription.


Professional Answers on Investments


Leave a Comment

If you are not satisfied with the above answers, tell us below and we will give you right answer.

OR

If you know the better answer, post below and prove your knowledge.


Previous post:

Next post: