Steve 1962
Active Member
- Joined
- Jan 3, 2006
- Messages
- 343
- Office Version
- 365
- Platform
- Windows
Hi
I am having trouble with this spreadsheet. I am running Windows XP and Excel 2003.
Thanks
Steve
I am having trouble with this spreadsheet. I am running Windows XP and Excel 2003.
Thanks
Steve
Book2.xls | ||||||||||
---|---|---|---|---|---|---|---|---|---|---|
A | B | C | D | E | F | G | H | |||
4 | VIEW 1 | Quarterly Rate | Base | 1st Quarter | 2nd Quarter | 3rd Quarter | 4th Quarter | Equivalent Annual Escalation | ||
5 | 4.663% | 1 | 1.047 | 1.095 | 1.147 | 1.200 | 20.00% | |||
6 | 0.047 | 0.049 | 0.051 | 0.053 | 0.056 | |||||
7 | ||||||||||
8 | Input quarterly rate into B5 and the result is shown in H5 as the equivalent annual rate | |||||||||
9 | ||||||||||
10 | ||||||||||
11 | ||||||||||
12 | VIEW 2 | Quarterly Rate | Base | 1st Quarter | 2nd Quarter | 3rd Quarter | 4th Quarter | Equivalent Annual Escalation | ||
13 | 4.225% | 1 | 1.042 | 1.086 | 1.132 | 1.180 | 20.00% | |||
14 | 0.042 | 0.044 | 0.046 | 0.048 | 0.050 | |||||
15 | ||||||||||
16 | Input annual rate into H13 and the result is shown in B13 as the equivalent quarterly rate | |||||||||
17 | Require cells C13 to G14 to have formulas which give the answer in B13 | |||||||||
18 | Answer should show 4.663% in B13 if 20% is inputted in to H13 | |||||||||
19 | Only cells available for inputs are B5 and H13 | |||||||||
Sheet1 (2) |