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
Jan 19, 2016 | Computers & Internet
Jul 07, 2015 | Microsoft Excel for PC
Apr 27, 2009 | Microsoft Excel for PC
Jan 13, 2009 | Computers & Internet
Dec 21, 2008 | Microsoft Excel for PC
Jul 14, 2008 | Computers & Internet
Mar 08, 2008 | Microsoft Excel for PC
Jan 09, 2008 | Computers & Internet
Jan 01, 2008 | Microsoft Office Standard for PC
Sep 26, 2007 | Microsoft Office Standard for PC
203 people viewed this question
Usually answered in minutes!
WHICH IS THE HUNDREDTH IN DECIMAL
×