Welcome Guest. Sign in or Signup

2 Answers

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

Asked by: 126 views , , , , ,
Misc

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

Those who found this page were searching for:

rupees and paise

2 Answers



  1. CDV on May 30, 2012 reply

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

    0 Votes Thumb up 0 Votes Thumb down 0 Votes



  2. hot-n-cool on May 30, 2012 reply

    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]

    0 Votes Thumb up 0 Votes Thumb down 0 Votes




+Admin


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


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.


Answer Question

Do you like this website? Get future updates via our Free newsletter.

Email ID:

 
 

InvestmentKit is also available in

USA

Australia

Our Network:

InvestmentKit.com DodaCharts.com IndianPostOffice.Helpof.com AnswersKit.com SBILifeInsurance.Helpof.com RTILeaks.com
PaisaYehPaisa.com PublicProvidentFundIndia.com TechnologyPedia.com MoneySavingsHelp.com VedicAstrologyKit.com OneReviewADay.com
YellowPagesKit.com InvestmentKit.us Saatwik.com   InvestmentKit.com.au  
 Privacy and Disclaimer  

 www.InvestmentKit.com

     
Insurance is the subject matter of solicitation.

Mutual Fund investments are subject to market risks. Please read the offer document carefully before investing.