Question about Microsoft Office Standard for PC

Re: excel

Suppose ur number is at cell B2 with any value. lets say u want formula in A3. then A3 =*b2*3/4 to round back the A3 to full number the simpliest solution is to change cell formatint to NUMBER and set the decimal places to 0.

Posted on Sep 17, 2007

Anonymous, that figures.

You want to "round up" the total, of "Bldg_Program[Floor], square # C43", Plus the "Bldg_Program[Total NSF] Times 1.05, minus 2.

Your answer will get rounded up to the next number.

You want to "round up" the total, of "Bldg_Program[Floor], square # C43", Plus the "Bldg_Program[Total NSF] Times 1.05, minus 2.

Your answer will get rounded up to the next number.

Mar 25, 2015 | Microsoft Excel 2010

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

Oct 30, 2014 | Microsoft Excel X for Mac

In Microsoft Excel, "rows" refer to data cells grouped together horizontally across a single line. The numbers on the far left of the screen refer to a row number. Similarly, the letters at the top of the workbook page refer to the columns.

Here is a picture to help:

In this example, there are 3 rows. All the cells in Row 1 contain the words "Row 1" and are color-coded orange. Likewise, All the cells in Row 2 are pink, and those in Row 3 are blue. Do note, however, that even though the boxes under the letter "F" aren't color-coded, they are still in the respective rows. Each color-coded line could extend for an infinite number of boxes, and each box of the same color would be part of that row.

If you find this solution helpful, please leave a positive rating!

Here is a picture to help:

In this example, there are 3 rows. All the cells in Row 1 contain the words "Row 1" and are color-coded orange. Likewise, All the cells in Row 2 are pink, and those in Row 3 are blue. Do note, however, that even though the boxes under the letter "F" aren't color-coded, they are still in the respective rows. Each color-coded line could extend for an infinite number of boxes, and each box of the same color would be part of that row.

If you find this solution helpful, please leave a positive rating!

Jun 22, 2011 | Microsoft Office Excel 2007 Full Version...

=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

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

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

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

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

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

=number^(1/3)

Nov 18, 2008 | Microsoft Office Professional 2007 Full...

Are you looking to solve any particular problem?--- because there are a huge number of possible formulas in Excel.

However, in my opinion, the most commonly needed ones are addition, subtraction, division, multiplication, and summing.

Suppose you have the following numbers typed into your Excel spreadsheet:

**columns: A B C D**

**rows**

**1 ** 20 3

**2 ** 10 4

**3 ** 15 2

**4 ** 1 2 3

Then suppose you type in the following formulas (in the D column):

**columns: A B C D**

**rows**

**1 ** 20 3 =A1+B1

**2 ** 10 4 =A2-B2

**3 ** 15 2 =A3*B2

**4 ** 1 2 3 =sum(A4:C4)

Then the following answers will appear in the D column:

**columns: A B C D**

**rows**

**1 ** 20 3 23

**2 ** 10 4 6

**3** 15 2 30

**4** 1 2 3 6

However, in my opinion, the most commonly needed ones are addition, subtraction, division, multiplication, and summing.

Suppose you have the following numbers typed into your Excel spreadsheet:

Then suppose you type in the following formulas (in the D column):

Then the following answers will appear in the D column:

Sep 29, 2008 | Microsoft Business & Productivity Software

you can use the Round function as below - it rounds out the decimal to 0 places, which gives you 5 digits with no commas

=ROUND(RAND()*100000,0)

=ROUND(RAND()*100000,0)

Jul 10, 2008 | Microsoft Excel for PC

columns total in additin cells of rows equal are total

Oct 24, 2007 | Oracle 10g Database Standard (ODBSEONUPP0)

Apr 25, 2014 | Microsoft Office Standard for PC

53 people viewed this question

Usually answered in minutes!

×