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
Jan 19, 2016 | Business & Productivity Software
Jul 07, 2015 | Microsoft Excel for PC
Apr 27, 2009 | Microsoft Excel for PC
Jan 13, 2009 | Business & Productivity Software
Dec 21, 2008 | Microsoft Excel for PC
Jul 14, 2008 | Business & Productivity Software
Mar 08, 2008 | Microsoft Excel for PC
Jan 09, 2008 | Business & Productivity Software
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
×