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

# Need formula to change the hundredth decimal place to "9"

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.

Posted by on

• Anonymous Jan 22, 2009

WHICH IS THE HUNDREDTH IN DECIMAL

×

• Level 1:

An expert who has achieved level 1.

Problem Solver:

An expert who has answered 5 questions.

• Contributor

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

• Level 1:

An expert who has achieved level 1.

Hot-Shot:

An expert who has answered 20 questions.

Corporal:

An expert that hasĀ over 10 points.

Mayor:

An expert whose answer gotĀ voted for 2 times.

• Contributor

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

Posted on Jan 02, 2017

×

my-video-file.mp4

×

## Related Questions:

### My excel worksheet - for a whole number you have to enter 1. or 9. or 10. How can I avoid the . and still get a whole number

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

### How to round 6.45734 to the nearest hundredth.

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!

Oct 07, 2015 | Office Equipment & Supplies

### How to calculate the percentage using the excel

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.

1. Create a blank workbook or worksheet.
2. Select the example in the Help topic. Note Do not select the row or column headers.
Selecting an example from Help
3. Press CTRL+C.
4. In the worksheet, select cell A1, and press CTRL+V.
5. 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.
1 2 A B Purchase price Sales tax (in decimal form) 800 0.089 Formula Description (Result) =A2*B2 Multiplies 800 by 0.089 to find the amount of sales tax to pay (\$71.20) Note To convert a number in percentage format to a decimal, divide it by 100. For example, the sales tax in this example (8.9) divided by 100 is .089.
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.
1. Create a blank workbook or worksheet.
2. Select the example in the Help topic. Note Do not select the row or column headers.
Selecting an example from Help
3. Press CTRL+C.
4. In the worksheet, select cell A1, and press CTRL+V.
5. 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

### Using sumifs formula accross multiple sheets

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.

Apr 17, 2009 | Computers & Internet

### Help me pls...

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

Jul 06, 2008 | Audio Players & Recorders

### Unsure of correct formula

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

Is it OK?

Mar 08, 2008 | Microsoft Excel for PC

### Exel 2003

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
1. Click the cell in which you want to enter the formula.
2. 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).
3. Click the tab for the worksheet to be referenced.
4. Select the cell or range of cells to be referenced.

Jan 01, 2008 | Microsoft Office Standard for PC

### EXCEL

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

Sep 26, 2007 | Microsoft Office Standard for PC

## Open Questions:

#### Related Topics:

203 people viewed this question

Level 3 Expert

Level 3 Expert