Question about Microsoft Office 2003 Basic Edition English (s55-00066) for PC

I need a formula for an interest rate worksheet. Cell A1 = 4.00% (which is an index - Wall Street Journal Prime). In Cell B1 I want to add a margin (e.g. 1.25%) to the index. In addition, I want to change the number in the hundredth decimal place to equal "9". I need the formula to add P+1.25%=4.25%, and then change the last digit to "9" (returning 4.29%).

In researching the Rounding function, I've only been able to return a "multiple" of 9 rather than changing the hundreth decimal place to "equal" 9.

If I understand correctly the Round function will round up to the nearest tenth for .05 and above and round down for .04 and below. I am not entirely familiar with the use of the rounding function in a spreadsheet but it seems to me that if you can specify to round down ALL hundredths to the nearest tenth and then add .9 you will get the result you want. Or conversely, round up and minus .01. If this is possible you may want to apply the round function in one cell and then use another cell to add/subtract to get your x.x9 as I believe functions are not always applied in left to right order as read but are apllied in a specific hierarchy, in which case the subtraction/addition could be applied before the rounding and be lost. Using separate functions would overcome this.

Posted on Dec 08, 2008

Try =round(x,2)-.01

Posted on Dec 03, 2008

Hi,

a 6ya expert can help you resolve that 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.

the service is completely free and covers almost anything you can think of (from cars to computers, handyman, and even drones).

click here to download the app (for users in the US for now) and get all the help you need.

goodluck!

Posted on Jan 02, 2017

Use Edit, Column or row, and format cell. then select type of number, integer or number of decimal places etc.

Nov 03, 2016 | The Computers & Internet

You don't need a calculator for that.

- A hundredth is 2 decimal places, so your number looks like

6.45 734

Add the 3rd digit to the right of the decimal to itself. You'll get

6.46 434

Ignore the digits except for two decimal places, you get

6.46

Ta Da!

- A hundredth is 2 decimal places, so your number looks like

6.45 734

Add the 3rd digit to the right of the decimal to itself. You'll get

6.46 434

Ignore the digits except for two decimal places, you get

6.46

Ta Da!

Oct 07, 2015 | Office Equipment & Supplies

Hide All

Percentages are calculated by using the following equation:

amount/total = percentage

Where percentage is in decimal format.

What do you want to do?

Calculate the amount if you know the total and percentage
For example, if you purchase a computer for $800 and there is an 8.9% sales
tax, how much do you have to pay for the sales tax? In this example, you want to
find 8.9% of 800.

Example
The example may be easier to understand if you copy it to a blank
worksheet.

- Create a blank workbook or worksheet.
- Select the example in the Help topic.
**Note**Do not select the row or column headers.

Selecting an example from Help - Press CTRL+C.
- In the worksheet, select cell A1, and press CTRL+V.
- To switch between viewing the results and viewing the formulas that return
the results, press CTRL+` (grave accent), or on the
**Formulas**tab, in the**Formula Auditing**group, click the**Show Formulas**button.

Calculate the percentage if you know the total and amount For example, if you score 42 points correctly out of 50, what is the percentage of correct answers?

Example The example may be easier to understand if you copy it to a blank worksheet.

- Create a blank workbook or worksheet.
- Select the example in the Help topic.
**Note**Do not select the row or column headers.

Selecting an example from Help - Press CTRL+C.
- In the worksheet, select cell A1, and press CTRL+V.
- To switch between viewing the results and viewing the formulas that return
the results, press CTRL+` (grave accent), or on the
**Formulas**tab, in the**Formula Auditing**group, click the**Show Formulas**button.

Simple way Amount/Total*100

Apr 30, 2011 | Computers & Internet

Here is the syntax: =SUMIF(Sheet2!A1:A3,"> 1", Sheet2!B1:B3)

This says if the cells A1 through A3 in worksheet "Sheet2" are greater than 1 then return the values from worksheet "Sheet2" cells B1 through B3.

Change the worksheet name Sheet2 to your worksheet name and change the cell references to the ones you need.

This says if the cells A1 through A3 in worksheet "Sheet2" are greater than 1 then return the values from worksheet "Sheet2" cells B1 through B3.

Change the worksheet name Sheet2 to your worksheet name and change the cell references to the ones you need.

Apr 17, 2009 | Computers & Internet

Am I doing your homework? lol

1. 0.90

2. 0.56

3. 0.600

4. 0.033

5. 0.071

6. 0.002

7. 0.0258

8. 0.8

9. 0.34

10. 0.0078

1. Nine Tenths.

2. Seventy Eight One Hundredths

3. Ninety Two One Hundredths

4. One Hundred Two One Thousandths

5. Two Hundred Seventy Six One Thousandths

1. 0.90

2. 0.56

3. 0.600

4. 0.033

5. 0.071

6. 0.002

7. 0.0258

8. 0.8

9. 0.34

10. 0.0078

1. Nine Tenths.

2. Seventy Eight One Hundredths

3. Ninety Two One Hundredths

4. One Hundred Two One Thousandths

5. Two Hundred Seventy Six One Thousandths

Jul 06, 2008 | Audio Players & Recorders

You can add a reference from the worksheet 1 to all other worksheets

Is it OK?

Is it OK?

Mar 08, 2008 | Microsoft Excel for PC

You can refer to cells that are on other worksheets by perpending the name of the worksheet followed by an exclamation point (**!**)
to the cell reference. In the following example, the AVERAGE worksheet
function calculates the average value for the range C1:C10 on the
worksheet named Marketing in the same workbook.

Refers to the worksheet named Marketing Refers to the range of cells between C1 and C10, inclusively

Refers to the worksheet named Marketing Refers to the range of cells between C1 and C10, inclusively

- Click the cell in which you want to enter the formula.
- In the formula bar (formula
bar: A bar at the top of the Excel window that you use to enter or edit
values or formulas in cells or charts. Displays the constant value or
formula stored in the active cell.)
, type
**=**(equal sign). - Click the tab for the worksheet to be referenced.
- Select the cell or range of cells to be referenced.

Jan 01, 2008 | Microsoft Office Standard for PC

It is very useful to learn excel shortcut realy i thank you

Sep 26, 2007 | Microsoft Office Standard for PC

204 people viewed this question

Usually answered in minutes!

WHICH IS THE HUNDREDTH IN DECIMAL

×