Want to set 4.8% in one cell and round off it how to do it ?

I have 100 rows. i want to set it for 4.8% roundoff to my total beneficeries column.
Finally i calculate the column and with eg: J is colum means J/100 = it need to come 4.8 how to do it ?

Set the cell to show no decimal places using cell formatting on the Home ribbon.

Try this:

=ROUND(J1/100,1)

Try stating the problem with full details at the start of a thread instead of expecting us to guess half of what you know but are not telling us. Also try the occasional "please" and "thank you" - they will go a long way.

for display as per AliGW suggestion post#2

If you want to use the rounded number (5%) in a calculation then with the 4.8% in cell E2

Formula:

Please Login or Register  to view this content.

@AliGW comments endorsed

Certainly not. You provide your workbook and then somebody will have a look for you. We are NOT going to do your work for you.

An average of 4.8% from a series where the amounts are all 5 is mathematically incorrect.

=AVERAGE(H2:H101) comes to 5, not 4.8.

Why do you want the answer of 4.8? You need to explain this, because it makes no logical sense.

Now you are SHOUTING at us. Please turn off your CAPS LOCK key and try explaining again why you want 4.8% to appear there. This makes no sense at all:

BELOW 5 NOT MORE THAN 4.8% AND OVERALL IT NEED TO COMES 4.8%

Instead of barking orders in your shorthand fashion, try taking a little more time to properly formulate your responses to our questions. Then you might get a better quality of reply.

Can you SLOWLY and without getting cross, please explain the logic behind your request.

As far as I can guess, this is what you want, but it doesn't make too much sense to me:

=MIN(AVERAGE(H2:H101),4.8)

@AliGW Quite a duel

Originally Posted by kev_

@AliGW Quite a duel

Not really. The OP just needs to learn to be patient and to show a little common courtesy to those who are very patiently trying to help him.

If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED. It would be nice, too, if you thanked Glenn for the solution that I assume you were looking for. Thanks.

Thank you for letting us know. Please mark the thread as solved.

Hello maddyrafi1987,

Your post does not comply with Rule 7 of our Forum RULES. Please do not ignore requests by Administrators, Moderators and senior forum members regarding forum rules.

If you are unclear about the request or instruction then send a private message to them asking for clarification.

Please mark the thread as solved as requested by AliGW.

Thanks.