Question about Microsoft Excel Computers & Internet

1 Answer

How to stop rounding in excel - Excel Microsoft Computers & Internet

Posted by Anonymous on

Ad

1 Answer

  • Level 1:

    An expert who has achieved level 1.

    New Friend:

    An expert that has 1 follower.

    Problem Solver:

    An expert who has answered 5 questions.

  • Contributor
  • 5 Answers

Trunc(cell number)

Posted on Aug 12, 2014

Ad

1 Suggested Answer

6ya6ya

6ya staff

  • 2 Answers

SOURCE:

Hi there,
Save hours of searching online or wasting money on unnecessary repairs by talking to a 6YA Expert who can help you resolve this issue over the phone in a minute or two.

Best thing about this new service is that you are never placed on hold and get to talk to real repairmen in the US.

Here's a link to this great service

Good luck!

Posted on Jan 02, 2017

Ad

Add Your Answer

Uploading: 0%

my-video-file.mp4

Complete. Click "Add" to insert your video. Add

×

Loading...
Loading...

Related Questions:

1 Answer

How do I round a formula result in the same cell?


Did you ever try round? or press F1 for help on this?

Oct 30, 2014 | Microsoft Excel X for Mac

1 Answer

I need help with an excel formula. I am looking to get to a retail price, knowing the cost and the margin. For example, the cost is $10.00, margin is 25%, so my formula would be =10/75%. The total would be...


=INT(A1)+0.95

With A1 being the reference to the cell you wish to round up
What that does is first round down the number to a whole one then adds 0.95 to the figure

Hope this gives you the information you need

Bob
Moderator

It would be very decent of you to consider the quality of our expert’s answers and judge them accordingly as you pass through FixYa.

Thank you

Mar 17, 2010 | Microsoft Excel 2003 (065-03992) for PC

1 Answer

Using an excel sheet, assume that sum of some cells is 100.77 and i want to use this sum in other cells but 100 in a cell and 0.77 in another cell, so what is the equation or what can i do to do it ??


You could use the round function to split the value around the decimal point (assuming that is what you want to do).

e.g. in one cell the value is Rounddown(ref cell)
in other cell value is refcell - Rounddown(ref cell)

Might want to check help file on "rounding" to confirm exact function name

Nov 24, 2009 | Microsoft Excel for PC

1 Answer

Word/Excel - trying to mail merge excel data into word document. Keeps carrying values out rather than following my Excel rounding to four.


Hi. I was pointed to a change in settings in Word that allowed the data to come over as I wanted.


Take care, Dennis

Sep 29, 2009 | Computers & Internet

3 Answers

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...


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

Aug 29, 2009 | Microsoft Office Excel 2007

1 Answer

Excel 07 truncuating problem


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).


May 06, 2009 | Keystone Excel 2007 Essentials for PC...

1 Answer

Need a replacement bowl for my Kenwood Chef


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.

Mar 13, 2009 | Food Processors

1 Answer

Rounding Time in Excel 2007


format the cells that contains times and net time worked as time format you using Enter the simple formula   =if(c14<=0,Int(0),(c14-c13))

Feb 04, 2009 | Microsoft Excel for PC

1 Answer

Rounding off numbers


check the standard tool bar, increase decimal places/decrease decimal places tool will solve your problem.

Nov 04, 2008 | Computers & Internet

1 Answer

Excel formula


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.

Feb 27, 2008 | Computers & Internet

Not finding what you are looking for?
Computers & Internet Logo

Related Topics:

20 people viewed this question

Ask a Question

Usually answered in minutes!

Top Microsoft Computers & Internet Experts

Ekse

Level 3 Expert

13434 Answers

Alun Cox

Level 3 Expert

2679 Answers

ThaMp3Doctor
ThaMp3Doctor

Level 3 Expert

8597 Answers

Are you a Microsoft Computer and Internet Expert? Answer questions, earn points and help others

Answer questions

Manuals & User Guides

Loading...