How to round the fig. in Excel 2007 E.g. 12350*32.75% = 4044.625 I want it to be rounded to nearer rupee. If the decimal is lesser than 50, rounded fig. should be lower Rupee if the decimal is more than 50 should be higher i.e. 4045

The function is called ROUND. It has 2 arguments, (1) the original number and (2) the number of decimal digits. Here is the Excel's help: ROUND(number,num_digits) The number you want to round. • None. num_digits The number of digits to which you want to round number. • If num_digits is greater than 0 (zero), then number is rounded to the specified number of decimal places. • If num_digits is 0, then number is rounded to the nearest integer. • If num_digits is less than 0, then number is rounded to the left of the decimal point.
So for your case use this in a cell "=ROUND(12350*32.75%, 0)" without quotes, where I assume one or both numbers will come from other cells. -Ken

Just follow these steps: Suppose you have 10 cells having values with decimal points that you want to change to no decimal values.
1. Select those 10 Cells. Right click on ANY ONE OF THEM. 2. Click on "Format Cells" 3. In the "Number" tab, there is a list of Categories. 4. Click on "Number" (given after General). 5. Decrease the Decimal Places: to zero. 6. Click OK
Please Rate if you found the above info useful. And please inform if the problem is solved or not.

Hello,

What you need to do is to right-click on the cells involved, and select Format Cells.

All you need to do is to lower the Decimal Places to 0. That should take care of the problem.

Thanks for using Fixya.