- If you need clarification, ask it in the comment box above.
- Better answers use proper spelling and grammar.
- Provide details, support with references or personal experience.
Tell us some more! Your answer needs to include more details to help people.You can't post answers that contain an email address.Please enter a valid email address.The email address entered is already associated to an account.Login to postPlease use English characters only.
Tip: The max point reward for answering a question is 15.
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_digitsThe 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
You need to use the ROUND function. E.g. type: =ROUND(A1,2)*A2
Assuming the 2.131576 is in cell A1 and 1000 is in A2. The round function round the value to 2 decimals (in this case because I specified 2 as the second argument).
I have an Excel that has the D shaped bowl but the base of it is round. Since the Excel does have a round base you can fit any existing bowl onto the Kenwood including their newer stainless steel bowl.
the formulae for the surface area of round disc is pi * r * r where pi=3.14 and r =radious of disc= diametre/2
for this 1st u have 2 calculate the radious of the disc that is 180/2=90mm then convert it to m by dividing 1000 ,so radious=90/1000=0.09 m finally calculate the area= 3.14 * 0.09 * 0.09=0.025434 sq metres for 38 disc multiply 38 with the above area that is 0.025434 * 38=0.966492 sq metres
in excel 2007 u can do it more easily by going 2 formulas tab. Under formla tab click on engineering formula and then convert here u can convert from mm to m after converting use the above formula i just told u.
×